CAnnot add record(s); primary key for table 'table1' not in recordset
Posted on 2004-11-08
I have table1 is a history table which contains fields primarykey, customerid, month, year, and other fields for the period
table2 contains customer info of 'a' given month/year
I want to 'update' table2 information to to table1.
I created query1, which contains all fields of table1, with criteria month and year set to the month and year I want to update.
I created query2, which has table1 left join with query1.
If query2 is a select query and I include primary of table1, then the query is fine and updatable.
However, if I made query2 an update query then I get the error message 'Cannot add record(s); primary key for table 'table1' not in recordset'. I can't include primary key for table 'table1' because it's an update query.