Help on Appending Tables

[Rhonda69]

Hi all,
Still very very green at this, appreciate any help. This one will be simple for you guys!

I need to combine two tables.

I know how to create an append query but the existing table (CustomerT) has the 'staff name' field as a foreign key/number. The incoming table has staff name as the actual names/text.

Is there a way to change the staff names in the incoming table to the foreign key so that I can append....or any other ideas on how to complete this task???

Thanks in advance
Rhonda

 

[CJ_London]

create a separate query linking the staff name in the incoming table to the staff table on staffname. Then pick up the StaffID from here