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......
Hi psamelson and welcome to the forum
Have a look at these two posts, they might be of help to you in accomplishing this.
Let me know if they do help or not, or need any clarification.