Search results

No not trying to append to the autonumber field, but trying to append to other fileds in a table with an autonumber. This autonumber field is also the primary key.

Hi, I have a table where there is a field set as autonumber. i want to be able to add information from another table using an append query, and for it to automatically assign an autonumber, but I get the error message saying that it cant append due to "validation rule violations". I want...