auto number

[Jen0dorf]

Hi



As readers of the forum will know I have been working on a database for weeks and thought I'd got it sorted. Thought being the word.

So I'vedecided to grasp all my new found knowledge andstart from scratch to loose all the mistakes I made.

However one question arises:

If you have a table with an auto number field and fill it with data say 1-10 if you delete the records and then re populate is it normal that the numbering starts from 11?

thanks

Ian

[Mahendra1000]

As per my knowledge.. YES.

if you have an auto number field and let's say you have deleted the total rows from 1-20 and if you want to enter then it starts from 21 not from 1.

Someone please correct me if am going wrong

Thanks

[NoellaG]

That is correct, the purpose of an autonumber field is to provide a unique key, nothing more. If you put the "New Values" property on "Random" you get a random number every time.
If you want a series from 1 to n without any missing numbers you can use a Dmax function to calculate the next following number.

Kind regards
Noëlla