I have a drop down menu that gets its value list from another table.
Is there a way to have the value list only show values when under a certain conditions?
My first table with the drop down list should show all the choreographer's names.
The other table that this value list is looking to is a contact list with many people with different titles.
I would like the value list to only show people's names that have the title of choreographer.
The titles and the names have their own field in the contact list table.