How do i create an offest autonumber to start at say 1000000?

[Mister Learner]

I am creating a database with a user ID and would like to save time by having
a column to create a random large number user id which is a unique identifier
with a offset value of about 1000000. eg. 1000001 Mr Joe Bloggs, 1000002 Mrs
Helen O'Toole, 1000003 Dr Tony Stamp etc.

 

[Brett Collings [429338]]

On Thu, 28 Oct 2004 11:45:06 -0700, "Mister Learner" <Mister

I am creating a database with a user ID and would like to save time by having
a column to create a random large number user id which is a unique identifier
with a offset value of about 1000000. eg. 1000001 Mr Joe Bloggs, 1000002 Mrs
Helen O'Toole, 1000003 Dr Tony Stamp etc.

There is a full explanation of how to do this in Help,
The keyword is
"Autonumber",
the explanation is titled
"Change the starting value of an incrementing AutoNumber field"


Cheers,
Brett