Specialized list from two tables displayed as drop down list?
I'm new to databases and need some help...
I have an employee table and a job table. I have two types of questionnaires that the employee fills out based on his job. So i have two separate tables for the questionnaires.
I want to have a drop down list of employees that match the criteria for the certain type of questionnaire. But I don't know how to create the list and I don't know how to get it displayed.