Im having a little trouble with the auto number,
I have a table with the auto as the primary key, the problem is that the autonumber for new records is less than the max value of the autonumber field.
eg
max value in key field (2254)
Value auto uses for a new record(2233)
I didnt think this...