to edit autonumber

[Harrold]

Hi

I create a table and use autonumber as its primary key. But its starting number is 3 instead of 1. Why is this case?

How can i make the autonumber start from 1?

Thanks

 

[DCrake]

It seems that at some stage you have added 2 records only to delete them later, therefore the next new record is number 3. If you want to restart at 1 then delete all the records from the table then run a compact and repair to reset the autonumber.

 

[Mr. B]

The AutoNumber field is designed to always produce a unique value as a record identifier. This is the only thing that the AutoNumber should be used for. This field should actually never be even diaplayed to end users.

When used as it should be used, there is no need to have the numbering start a 1.

Keep in mind that as you use your database and delete records, the Numbers in the AutoNumber field will never be reused and therefore numbers will be missing.

If you need an incrementing sequence number for some purpose the you should use some other method for that.

 

[gemma-the-husky]

but it shouldn't matter. autonumbers are capricious beasts at times, and you shouldn't use them to try and manitain a sequence. if a sequence matters to you, then use a different technique.