I have a form that has two drop down lists. The first drop down is where an employee name is chosen from the employee table.
I want the second drop down to populate the employee's position title, which is in the employee table.
If the second drop down needs to be just a text box I can change that.
How do I configure this.