My DB currently has two tables, one containing project information and another one with team member names. I have a one to many relationship setup on a 'name' field in both tables. One team member to many projects.
In the form I setup a dropdown box to query/filter the project table by Team member name. To do this I have to setup a secondary ...