Auto-numbering gone haywire!

[sunserve]

Although there are few records in my database, the auto-numbering started at 45. So I deleted all the records so I could start from zero but it still happens. I checked all the properties of that field both in the form and the table itself and I can't find the problem. Any ideas would be most appreciated.

 

[antomack]

Generally to reset the auto-numbering you need to empty the table and then compact the database. The compacting generally resets the autonumber to start from 1.

 

[RuralGuy]

The fact that you find the number important makes me suspect you are probably not using the AutoNumber field properly. It is for a unique number *only* and *never* to be seen by the user. It is usually used as a primary key (PK) of a table.