Is it possible to modify the auto fill beginning number

[JWS]

In designing my work order database I would like to use the auto fill feature
for my key and Work Order ID. Is there any way to modify the starting number
to other than 1?

We have thousands of previous work order in hand written form and we would
like to continue with the last number used (for example work order 5864) and
have the auto-fill feature begin with that number.

Thanks

 

[Duane Hookom]

I assume you understand the limitations of using an autonumber for any value
that might get displayed to users.

Create a table or query that returns a single record with the value 5864.
Append this to the autonumber field of your new table. Then delete the
record and the next new record should have the number 5865.