Update or Append Query

[blue_echo]

I have two tables 'Customers' and 'Employers'. I need to update the CustomerID field in the Employers table to the CustomerID from the Customers table(primary key). I've tried using both the update and the append queries but all it does is add additional records to my employers table; not updating the existing info.

[John_G]

You have given us very little to work with - it would help if you showed us the structure of the two tables. That said, you are going to need some data (a field) in the Employers table to indicate which record in the customers table contains the new CustomerID value. If you don't have that, you cannot do what you want to do.

If it is a one-to-many relationship between the two tables, which is the "one", and which is the "many"? In other words, does one Employer have many Customers, or is it the other way around? Give us more detail, please.

[blue_echo]

It is one-to-many. One customer with many employers. My primary key in the customers table is the customerID. I already have all the customer's employers in the employers table with their wages, etc. The relationship on the two tables is on the customer ID. But bc I had to bring their employers over separately the customerID is blank in that table. I was hoping to update that field with the respective customer. If that makes sense.

You have given us very little to work with - it would help if you showed us the structure of the two tables. That said, you are going to need some data (a field) in the Employers table to indicate which record in the customers table contains the new CustomerID value. If you don't have that, you cannot do what you want to do.

If it is a one-to-many relationship between the two tables, which is the "one", and which is the "many"? In other words, does one Employer have many Customers, or is it the other way around? Give us more detail, please.

[blue_echo]

Customers:
CustomerID(PKey)
Name
Ssn#
Address1
Address2
Address3

Employers:
EmployerID(PKey)
CustomerID
EmpName
Address
Wages
Year
QTR

[John_G]

Unfortunately I think you're out of luck. The only common field between the two tables is CustomerID, and because there is no data in that field in the Employers table, you can't link them, so you can't automatically populate the CustomerID field in the Employers table.

Might that information exist elsewhere, maybe in an Excel spreadsheet?

Sorry I can't be of more help.