Hi there,
I have created a database which seems to be working ok. When I create new entries, access automatically assigns ID numbers. However, when I delete entries, the ID disappears and the next entry jumps an ID number.
Basically I want all my entries to have consecutive numbers for practical purposes. How can I do this? :/
I can't manually change ID number because it's part of the autonumber feature(i think!). Is there any way of recalibrating/adjusting ID numbers?
TY