Auto Data Entry

Hello All,

I was hoping someone could tell me the correct method of performing my intented function.

I would like for Access to Auto Input data from another table based on one entry in the current table.

Table 1 consists of Field 1 (Part Number), Field 2 (Serial Number) & Field 3 (Description).

Table 2 has Field 1 (Part Number) & Field 2 (Description).

Based on the info from table 2, how do I get the program to auto input Field 3 from table 2 (when I type in Field 1 in table 1)?

Thanks in advance