Help on Appending Tables

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:confused:

Help on Appending Tables