Auto Number

[SteveE]

I have used an autonumber as my identifer for each record, the operators use this number for purchase orders etc. due to errors encountered whilst importing the auto number has jumped from 47896 yesterday to 37883539 today, whilst only 45 records were imported. my operators are complaining like mad, reports need to be resized to accomadate etc etc.

My question is can the auto number be re-set to a specified number?

any help or suggestions appricated.

 

[yellow]

See this Should help you out..

 

[SteveE]

AutoNumber Setting

Thanks I tried that and I can see it works for setting a new start autonumber but no on my problem unless I doing something wrong.

 

[namliam]

This is why you shouldnt show an autonumber to "normal" users....

 

[SteveE]

Autonumber setting

Thanks Pat
I worked on my problem yesterday before I got your post and I was able to fix my problem in a backward way by: creating a copy table, appending from the original only data the with the correct auto numbers, then re-importing the bad number records and then renaming the original table and the new table to the original table names, re establishing the relationships etc, this applied new numbers to the bad records in the correct sequence and now new records are added ok.

Just as a side note where would the function in your link be placed to work?

Thanks again

Steve