Initializing Autonumerics values to 1

[Lina Manjarres]

I need to have all my autonumeric values to start in 1.
How can I do that?

Thanks a lot, Lina

 

[Alex Dybenko]

Hi,
if your table have no records - then you can compact database in order to
reset numbering to 1.
Anyway - idea of autonumber field is to provide a unique number, and nobody
should rely on it actual value.

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Lina Manjarres]

Thanks a lot.
Why do you say I can't relay on the autonumber?

 

[Alex Dybenko]

Hi,
I mean that you can not be sure that it will be correct sequence, or next
number will be last +1
If you need some meaning number, say order number, then you have to make
your own function to generate such number and use a normal number field,
long for example

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Lina Manjarres]

Thanks a lot!

Hi,
I mean that you can not be sure that it will be correct sequence, or next
number will be last +1
If you need some meaning number, say order number, then you have to make
your own function to generate such number and use a normal number field,
long for example

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com