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
I don't think this is going to work for me. I've set up a conditional dropdown but the problem is that on a form I'm limited to only using it once. I want to be able to add a Shoot record and on the form have fields to include one photographer, two stylists, one art director, one digital tech etc. etc.
To do that I'm going to have to create a vast array of fields inside Talent and Shoots in order to create and link together conditional dropdowns for multiple Talent Name and Talent Type fields for use on a single form. It seems incredibly tedious and hard to manage.
Honestly I think it would be easier to have a table for each of the Talent Types and do it that way. Perhaps I can still have a master Talent table but instead use Actions or Relationships to feed child tables with each Talent Type.
To do that I'm going to have to create a vast array of fields inside Talent and Shoots in order to create and link together conditional dropdowns for multiple Talent Name and Talent Type fields for use on a single form. It seems incredibly tedious and hard to manage.
Honestly I think it would be easier to have a table for each of the Talent Types and do it that way. Perhaps I can still have a master Talent table but instead use Actions or Relationships to feed child tables with each Talent Type.