wrong increments in Autonumber ID.

Ssstacey

Registered User.
Local time
Today, 13:22
Joined
Aug 9, 2005
Messages
48
On one of my forms the ID jumps from 35 to 2534. it is Autonumber and the new values are s'pose to be increments?

Does anybody know why this happens?

Thank u
Stacey
 
Well if you delete records, the autonumber carries on from where it got to, not from the last existing record. Have you deleted ~2000 records?
 

Users who are viewing this thread

Back
Top Bottom