Value List that dynamically omits records
Here is what I'm trying to do:
I have a coniditonal value list with names of people in it based on the group I select in another field. This value list is in a layout that has fields that represent where each person is in a group photo e.g. front row position 1 = front first left.
As I select a name and enter it into each field I want the next position I select to omit the record that has already been used so that as you enter names there are less and less to choose from thereby making it quicker and quicker as you fill fields.
In a nutshell I want the value list to dynamically omit records based on the populated values of the postion fields in my layout.
Is there a simple way to do this?