Restricting form fields to where user can only select info from another table

[Sara]

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!

[pbaldy]

Use a combo box and set the limit to list property to yes.

[Sara]

That gave me a combo box with no options available. I have the relationship made between tables. It's not recognizing the data from the other 2 tables.

[aytee111]

Combobox for technicians, set row source to SELECT Id and technician name, set number of columns to 2 with widths 0;2, set Limit to list = Yes. Bind this field to the TechID in table 3.

Do the same for procedures.