Update using JOIN query (A97)

Topic

New Reply

I am joining 2 tables using 2 fields surname & forename in each table. I want to update table1 with the EmployeeId from table2, but I get the error “Operation must use an updateable query”.

How should I perform this simple update?

Thanks

Reply | Quote

Replies

You need to have a unique key in Table2 on the combination of surname and forename. If you can’t create such a key, the combinations are not unique, and Access won’t be able to determine which EmployeeID belongs to a given surname and forename.

Reply | Quote

Makes sense now – thanks.

What I will do is summarise table 2 and ignore any that have multiple entries…hopefully that will work.

Reply | Quote