how do i keep autonumber in the right sequence

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Seering said:
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.
Click to expand...

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.
 
Back
Top