Auto numbering

[Keiath]

I have a database that has order numbers, I want to start the auto number at 7013 instead of 1 from the table, but there doesnt seem a simple way to do this

any ideas?

thanks

 

[pbaldy]

Try executing this query:

INSERT INTO TableName (AutonumberFieldName)
VALUES (7012)

 

[Keiath]

Done by having a auto number and a order number and via a calculation, messy but it works

 

[gemma-the-husky]

you don't want to use autonumbers, though, if you need an intact sequence.

either get the number from a separate table, or get the number with dmax.