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
What is the relationship between Talent and Shoots? It sounds like many-to-many which means you need an intermediary table, let's call it "Talent at Shoots". So users would have to save a record for Shoot and then add Talent at Shoots records as children.
Another option is to create multiple parallel one-to-many relationships between Shoots and Talent. One relationship for each of photographer, stylist, etc.
With either option, you can create a report in Talent that filters to just records with a value of "photographer". Then set this report as the record picker for when users are selecting the photographer on either the Shoot or Talent at Shoot form. You'll make a second report in Talent that filters to values of "stylist", and so on.
Another option is to create multiple parallel one-to-many relationships between Shoots and Talent. One relationship for each of photographer, stylist, etc.
With either option, you can create a report in Talent that filters to just records with a value of "photographer". Then set this report as the record picker for when users are selecting the photographer on either the Shoot or Talent at Shoot form. You'll make a second report in Talent that filters to values of "stylist", and so on.