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
Still not having any luck with this. The only option I've found that works is to create a table for Photographers, another table for Stylists, another table for Art Directors and so and, and then use these tables as a picker for the dropdown menu.
What I don't like about this method is that I'm going to end up with 10 different tables, one for each of the crew member types. I would prefer a master table that includes them all and for them to simply have what their crew member type is in another field. This will make the app much easier to use.
I'm playing with the idea of pulling all of the records from each of the 10 tables into a separate master table but the problem there is that it's going to be hard to create relationships between so many tables.
Surely there is an easier way of creating a dropdown that says "if CrewType=Photographer, show the key field (ie. photographer's name) in a dropdown menu". It doesn't sound like it's that hard but for some reason this is turning into an ordeal.
What I don't like about this method is that I'm going to end up with 10 different tables, one for each of the crew member types. I would prefer a master table that includes them all and for them to simply have what their crew member type is in another field. This will make the app much easier to use.
I'm playing with the idea of pulling all of the records from each of the 10 tables into a separate master table but the problem there is that it's going to be hard to create relationships between so many tables.
Surely there is an easier way of creating a dropdown that says "if CrewType=Photographer, show the key field (ie. photographer's name) in a dropdown menu". It doesn't sound like it's that hard but for some reason this is turning into an ordeal.