Replace A Deleted AutoNumber (1 Viewer)

[wizcow]

My invoice form is based on my invoice table.
The invoiceID is an auto number, wich is related to the invoiceSub.

I have deleted an invoice (9066).
I still have 9065 and 9067.

Is it possible to replace a deleted autonumber?
I would like to put 9066 back in.

 

[dcx693]

Autonumbers should only be used to uniquely identify records. They should have no intrinsic meaning and no other relationship with your data. That said, if you really want to do this, delete record 9067, compact your database, and the next autonumber should be 9066.