Dennis,

Thank you for replying. We've been using this db for about nine years and
have just now reached a 5-digit series of numbers. To reach this number
again is so far in the future, I don't think it would be a problem. I'm
more concerned with how to leave the current open jobs in the same db but
still start over with new numbers (perhaps with another field as suggested
but then how do I search for both and have both fields in queries) and make
users happy in doing so.

I'd welcome any further suggestions or advice.
Thanks,
Pam



"Dennis" wrote in message
...
Pam,

Another issue that Jeff alluded to, but did not metion. What happens when
your revised 4 digit job number reach the 5 digit in another 9000 jobs for
the third time? At that point, you will have three jobs with the same
number.

Can you add a field like year and start your count each year at 1000. The
actual job number would be year and job number, but you could print the
year
in one spot and the 4 digit job number in another spot?

I agree with Jeff on adding a new field (or two) instead of another
database
since you will have to add a 3rd database when you second series of job
numbers run out.

Good luck,

Dennis