This seems pretty easy, but I'm struggling getting it to work...
I have two tables currently. Table 1 is a list of all Technicians names with ID number. Table 2 is a list of all Testing Procedures.
I need a form so that the user selects a technician from Table 1, then selects a Testing Procedure from table 2, and then enters other info like dates, and that data set is saved in Table 3.
Right now I have it to where the user can type any any name or test into the form for Table 3. I need the user to be restricted to only be able to select a technician or test from table 1 & 2.
Any help would be much appreciated!