ID numbers and record numbers

[Phil]

What key did you hit?

If your ID numbers and record numbers don't match, it would seem some
records got deleted.

Double check that!

Phil

 

[Guest]

I recently hit a wrong key and now my ID numbers and record numbers don't
match. What can I do to make these two numbers the same?

 

[Douglas J. Steele]

I'm assuming your ID number is an Autonumber. Autonumbers exist strictly for
the purposes of providing a (practically guaranteed) unique value that can
be used as a primary key. They are not guaranteed not to have gaps in their
numbering. You can't change the value of an Autonumber once it's set.
Fortunately, you shouldn't care about it.

 

[Joseph Meehan]

I recently hit a wrong key and now my ID numbers and record numbers don't
match. What can I do to make these two numbers the same?

I suspect that your "ID number" is an autonumber. I suggest you may not
want to use Autonumber for that use. Autonumbers are designed to provide
unique numbers. It in not designed to provide numbers in order and for a
number of reasons may not do so. As a result using them in any application
where the user sees the numbers is likely to end up with confusion.

There are other ways of providing the numbers you want depending on the
particual application.