Need macro to update a combobox name field that is resides in another table after an import

[flmoeron]

I'm helping out a client move data between two systems. A .csv file is being imported into a table "LABOR" that includes hours worked and an employee id (text - labeled EMP #). Another table named "SERVICE TECHS" contains the employee name (combo box - labeled NAME) as well as the employee id (text - labeled EMP #). What I'm looking for is a macro I can run after the data has been imported into the table "LABOR" that looks at the employee ID in the "LABOR" table, cross references it to the "SERVICE TECHS" table and updates the employee name (combo box - labeled NAME) in the "LABOR" table accordingly.



So if I import a record into the "LABOR" table that has employee ID of 1234 and according the to the "SERVICE TECH" table, employee ID 1234 is John Smith, after importing the 8 hours that employee ID 1234 worked, I want to run a macro that updates the employee name (combo box - labeled NAME) record in table "LABOR" to reflect the value of John Smith.

This is probably Access 101, but I'm not overly proficient in Access...I can use VLOOKUP in Excel like no tomorrow, but I'm not certain how to accomplish this in Access.

Thanks in advance for assistance!

B(c)

[June7]

Why is employee name being saved in LABOR table? This is duplication of data. Only the EmployeeID should be in LABOR table.

Retrieve the employee name in query that joins tables on EmployeeID fields. This means EmployeeID in SERVICE TECHS table should be defined as primary key.

That is Relational Database Principles 101.

Advise no spaces or special characters/punctuation (underscore is exception) in naming convention. Also, no reserved words as names and title case is better than all UPPER CASE.

[nick404]

A list of reserved words in Access: https://support.office.com/en-in/art...7-da237c63eabe