I have two tables in the database I'm working on from Excel.

Table1 has demographic information for faculty, to which I added an AutoNumber Primary Key.

Table2 has the courses those faculty members taught, but it does not have the FacultyID I added to Table1; it has their last name, first name.

Is there a way I can have Access look up the employee's FacultyID from Table1 based upon their last name and first name, which are contained in both tables?

Thanks in advance.

LEFT JOIN on first and last name from Table1 to Table2. This is not a good method though as the moment you have faculty members with the same name, data integrity is lost.

A better solution is to make an update query using the same joins as above, add a new field to Table2 called facultyID, and update facultyID in Table2 with the autonumber from Table1.