I
Ian Rollo
Guest
Access 2000 using Windows 98.
I have established the temp table and append query as disignated in the Help section.
The query runs correctly and inserts a row with the temp table number into the AutoNumber field.
When the inserted number is greater than the last number in the table the new data is incremental on the inserted row.
However, when the number resets to a lesser number than the last entry on the table and data is entered (both via a form or directly) into the table the new row AutoNumber is an incremental increase of the old series, not the inserted row.
Can anyone tell me why?
Thanks
I have established the temp table and append query as disignated in the Help section.
The query runs correctly and inserts a row with the temp table number into the AutoNumber field.
When the inserted number is greater than the last number in the table the new data is incremental on the inserted row.
However, when the number resets to a lesser number than the last entry on the table and data is entered (both via a form or directly) into the table the new row AutoNumber is an incremental increase of the old series, not the inserted row.
Can anyone tell me why?
Thanks
