Filter Multi-Select from another Table
I have two tables, Talent and Shoots. Talent is a list of potential crew members for upcoming photo Shoots. In Talent, next to a person's name is the type of crew they are, for example Photographer...
Forum Discussion
This should not be complicated. You want to be using a conditional drop down.
In the Talent Table I assume that each Talent entry Record has a drop down for Talent Type.
Then in the Shoots table, instead of having a field dedicated to photographer, you can have a field called Talent Type 1. So you would choose say Photographer. Then you will choose the Talent Name 1 and on the field for [Related Talent 1] you will look for the box that is about Conditional drop down and make it so after choosing the field Talent Type 1, then limit choices to where the Talent has that Talent Type.
In the Talent Table I assume that each Talent entry Record has a drop down for Talent Type.
Then in the Shoots table, instead of having a field dedicated to photographer, you can have a field called Talent Type 1. So you would choose say Photographer. Then you will choose the Talent Name 1 and on the field for [Related Talent 1] you will look for the box that is about Conditional drop down and make it so after choosing the field Talent Type 1, then limit choices to where the Talent has that Talent Type.