I suggest you use a parameterized view of the dataset where that parameter
value is NOT equal to the column. Then, simply plug in the value and close
and open the dataset manually.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <spou@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, October 23, 2001 9:37 AM
Subject: [IBO] negative master-child possible ?


> Hi there. it's me again, with an other "newbie question of the
> day(TM)"
>
> /<serious mode on>/
>
> I would like to know how can I do a negative master-child link.
>
> I am working on a group rights system, a bit like you can see in many
> admin software, such as NT group admin.
>
> I have 3 grids.
>
> -the first one gives the list of existing groups:
> "select group_name, group_id from group_reference"
>
>
> -the second grid, a child linked of the first one, gives access rights
> assigned to the group:
> "select group_id, rights_allowed from permissions"
> with a masterlink of "group_reference.group_id=permission.group_id"
>
>
> -I would like the third grid to give the other available rights,
> *minus* the ones already displayed in grid 2, something like:
> "select right_name,right_id from rights"
> with a masterlink of "permission.right_allowed<>rights.right_id"
>
>
> this would allow to completely automatize the display of all the
> rights depending on the group selected in grind 1.
>
> all that would be left would be transfert the right_id from/to the
> available grid by adding or deleting the right_id in the permission
> table
>
> maybe I'm not clear enough, if so, feel free to ask clarification.
>
> TIA for any help,
>
> Spou