Autonumber

[Nick]

Hi

A quick one I think !! Can you set the autonumber to start
at anything ?? I would like my autonumber to start at
1..... but I would also like it to have 4 digits...for
example the first record will look like

1001
1002
1003

etc...just an after thought what would happen (if!!) I was
to get to 1999- would it go to 2000 or would it crash !!!

Thanks

 

[Pavel Romashkin]

You can make the autonumber start with anything you want provided your
table contains no records yet.
This is a wrong way to use autonumber, though. AN is not guaranteed to
abide to any typical rules you would expect, and if you do use it for
sequential numbering, we will be seeing your questions here later - Why
do I have gaps? How do I reset AN? How come I have AN like 1, 2, 3, and
then immediately 45009, 556021?.
AN should not be used for anything other than a unique ID for records.
If you are looking for a meaningful numbering, create a Number field and
fill it in yourself.

Pavel