how do i keep autonumber in the right sequence

[Guest]

i set up a autonumber column to use because the order number for the records
i typed kept changing now, although i have an autonumber it records #s even
if the record has beed deleted example.

1st record auto# 1
2nd record auto # 2
If I delete 2nd record when I go to type the next record it records as auto
number 3 instead of auto number 2.

 

[Rick Brandt]

i set up a autonumber column to use because the order number for the records
i typed kept changing now, although i have an autonumber it records #s even
if the record has beed deleted example.

1st record auto# 1
2nd record auto # 2
If I delete 2nd record when I go to type the next record it records as auto
number 3 instead of auto number 2.

If you care about the value in any way other than uniqueness then DON'T use
an AutoNumber. There are numerous (normal) activities that will produce
gaps in an AutoNumber sequence.