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.