AutoNumber

Hi,

I have a table that holds information for jobs. The job number is an auto
number field. It has grown to a 5-digit number and users want to start over
at 1000 due to problems with number spaces in accounting system. I could
start a new database, but the problem is with jobs that are still working
the the current db. That would cause users to run two db's until the jobs
in the first db are completed. I thought about making the current job
number field a regular number and then entering a new auto-number field for
job numbers, but how would they search for both the 5-digit numbers and the
new numbers?

Does anyone have any suggestons as to how I can start a new list of numbers?

Any help is appreciated.
Thanks,
Pam