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