ID numbers and record numbers

P

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
 
D

dgwright3d

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?
 
D

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