I have 2 many-to-one tables.
Both the Ppty_ID and UnitID fields are indexed and allow duplicate values in each table.
If the Ppty_ID and the UnitID fields are the same in both tables, I want one to overwrite the values in one of the tables based on a DateModified field.
I keep getting the error: "Operation must use an updateable query."
Neither has a primary key, and I can't use an autonumber field in each table to create a primary key.
Is there another workaround to get this done?
The query and tables are in the attached.