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
If you want to have a single master table of Talent (people) and fixed slots for each talent type for each shot, then yes you will need a relationship for each slot. You can still have a Conditional Drop down, but cheat the process by making a formula text field called [Photographer words] with the formula of
"Photographer"
Include that field on the form in a hidden section an admin only section.
Set the [Related Talent] field (which you can rename to be [Related Photographer] to be conditional on only where the talent type matches the value in he field [photographer words].
Get that drop own working on the form.
Then you can copy the field for [Related Photographer]. Most conveniently, Quick Base will also duplicate that relationship for you. So you just rename that field to [Related Stylist 1] and carry on to look up the name of he Talent and make that field [Stylist 1 Name] the proxy for [Related Stylist 1].
It's not really tedious, it is just that you have never worked with CDDs before, so they are new to you.
Mark
"Photographer"
Include that field on the form in a hidden section an admin only section.
Set the [Related Talent] field (which you can rename to be [Related Photographer] to be conditional on only where the talent type matches the value in he field [photographer words].
Get that drop own working on the form.
Then you can copy the field for [Related Photographer]. Most conveniently, Quick Base will also duplicate that relationship for you. So you just rename that field to [Related Stylist 1] and carry on to look up the name of he Talent and make that field [Stylist 1 Name] the proxy for [Related Stylist 1].
It's not really tedious, it is just that you have never worked with CDDs before, so they are new to you.
Mark