AutoNumber or elsewhere?

[jmenche]

Howdy,

I am setting up a database and I am trying to use an autonumber field as a unique identifier. As I play around with the Tables my autonumber fields start to look like 1, 2, 3, 9... Is there anything that I can do about this? Maybe an autonumber is not the answer and a custom function is?

P.S. You get extra points if you got the Frank Zappa reference in the title.

:beerchug:

[Norie]

jmenche

The autonumber doesn't actually need to be in sequence, it's actual value isn't relevant, or shouldn't be anyway.

[OBP]

If you want to reset it when you have finished developing it then delete all the records from the table and then Repair & Compact the database.
This will reset the Autonumber back to zero.