AutoIncremented Numbers (1 Viewer)

[wop0703]

Can I have a primary key in my table as an autoincremented number that starts at, say 618 instead of 1??

 

[JoeCruse]

The short answer is yes. Do a search on the site on custom autonumber or on seed. You can seed the autonumber field to get it to a certain number, if you need. Pat Hartman has posted the solution here, and you'll find her method when you do the search.

 

[neileg]

Autonumbers are not ideal for a field that has meaning to the user. By suggesting a specific starting value, this implies a meaning for this field. There are many situations where you can get gaps in the sequence of an autonumber, which may not be what you want. You can generate your own numbering sequence by using DMax() to find the largest existing number and incrementing that by one. This has been covered in these forums before, too.