I have a form in an Access 2010 file that is used to move records to one of two tables (both of which are linked). If the user selects "Reject" the record is moved to the Reject table. Today the user was able to move 18 such records to the Reject table but there is one that will not move. I tried running the append query manually and receive a message saying "Access unable to append record to a table due to key violations". I'm not able to determine what these violations are.
The data for the record looks good (no corruption). All required fields are populated appropriately with text, date, or numeric values. The primary key in the receiving table is an autonumber field and the append query makes no reference to it. All indexed fields in the receiving table allow duplicates. Visually everything looks fine but clearly something isn't right.
Any suggestions on what else I should look at would be greatly appreciated.