Best way put a subset into a drop down box
I have a database of performers who have different skills. A second database for shows on different dates is populated from the performer database. I would like to have a drop down list for each skill that shows just those performers with that skill set.
Some performers have multiple skills, so I set up a field (selections made with check boxes from a value list) that reflects what each performer can do, some having only one and others multiple skills.
I'm not sure the best way to proceed with this......