Paired-down drop-down options
I have a programming challenge in which I have a table of people’s initials versus a list of their qualifications. Then I have a second database that has duties complete with drop-downs of the people’s initials. Unfortunately, the drop-down shows everybody, when what it really should show is only those individuals who are qualified in that area and aren’t tasked to another duty.
The bottom line is, I’d like to mull over an example file that successfully demonstrates a similar challenge. Does anybody have one?
Thank you in advance for your insight.