self-depleting value list

[gaby78]

Here is my problem:

I have a field based VL.

How can I set it up in such way that once a value has been chosen, it is no longer available for the next record.

For example I have a coaches table and a players table. Once players have been associated to a coach their names should no longer appear in the value list when I want to associate other names to another coach. This way the list becomes shorter and shorter as assignments are completed.

This is to prevent a player's name to be linked to 2 different coaches.

Thanks for any suggestion.

[-Queue-]

Do a search on this site for "dwindling value list".