I have a macro that is trying to execute an append query to a table with an autonumbered ID field (which is my key field) but it keeps failing. I have all sorts of other append queries to the same table with no issues, so I am completely baffled.
The way I have this structured is that I choose records from my table (tbl_prepare_financials) and then attempt to duplicate those records. I am NOT appending the key field as it is my assumption that the autonumbering will occur when the records are appended. Is this wrong thinking? I even tried making the select activity ONE query, and then the appned query is based on the select query, but still keep getting 7 key violations. If I "Un-key" the autonumber field, it works but then creates duplicate IDs.