Filter items out of a values list

[EllenG]

I am trying to automatically filter out items in a valueslist once a value is selected.

Table 1: Animals

Field: Herd_ID

Field: Name

ValuesList = Name from Animals table

Table 2: Group

Field: Herd_ID

Group uses the Names list from Animals to select animals for a selected Group. When a name is selected from the list, the related Animals::Herd_ID is stored in the Group::Herd_ID field.

Is there a way to filter out that selected animal from the Names list, so the user cannot select the same animal again?

For example:

Name List display (1st time):

Adam

Betty

Carl

David

User selects Carl.

New Name Lis display:

Adam

Betty

David

Right now, I am running a script-trigger that looks for a match on Herd-ID when a name is selected. It works, but would prefer to limit the list to available names (eliminating all names already included.) Have other uses for this as well, if there is a way to do it.

Animals can be included in many groups, so Herd_ID in the Groups table cannot be unique.

Thanks.

[comment]

See:

http://fmforums.com/forum/showpost.php?post/274656/