Fred,

Thank you for the simple solution. I never thought of making the leading
digit invisible or just plain dropping it and starting the new db with my
four-digit numbers and letting the autonumber pick up from where the "in
progress" jobs leave off.

This is so much easier.

Thank you for your input.
Pam

"Fred" wrote in message
...
Echoing what Jeff & Dennis have said, it's a bad idea to mess with your
primary key or unique record identifier. That's one problem with using
your
unique identifier field have some type of other meaning, or be exposed to
others. It opens it up to the possibiity of somebopdy wanting to "mess"
with
it.

- - - -


Here's a simpler solution. Make the last 4 digits of your autonumber
field
be the "job number" for external consumption. You could just show them
those 4 digits, and keep the leading digit invisible to them. Best of
both
worlds.