I imported data into a field, and the autonumber works fine from 1 to 80000, but when i append data to this table, the auto number jumps to 900000. How do I append data to a table so that i get a continuous autonumbering?
Once an autonumber is used it will never be used again. They will go sequentially, but if you had 80,000 records and then deleted them, when you did another append, the autonumber would 80,001 and not 1.
The only way you can get the autonumbers to start over (and honestly, there really isn't a need to) is to copy the table (choosing definition only) and then fix all the relationships to the new table.