Consecutive ID numbers

[jdvd]

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

[jdvd]

Hmm, thought of a solution

(for those interested, just changed input from autonumber to number and then entered manually. Pretty easy!)

[ssanfu]

Basically I want all my entries to have consecutive numbers for practical purposes.

I can't manually change ID number because it's part of the autonumber feature

FYI......

The Autonumber field type is simply a way to create a unique identifier for each record. It should NEVER be treated as a meaningful piece of data.

Autonumbers are not guaranteed to be sequential, or even positive.

If you need to have consecutive numbers, you have to create and manipulate the numbers yourself. You will need to create a sequence number that you increment yourself and apply to the record when it is saved. (You can still keep the autonumber field to provide a unique identifier)