Autonumber

[Evan McCutchen]

Hello,
I'd like to be able to choose how an autonumber is done via forms. For
example, i have 1 database that is replicated between two offices. I'd like
to affix A at the begining of the autonumber of any record entered by our
office here in the US and an E at the begining of any record entered in
Europe. How would you go about doing this?

Thanks
Evan M
evan AT radiologyonesource DOT com

 

[LarryP]

-----Original Message-----
Hello,
I'd like to be able to choose how an autonumber is done via forms. For
example, i have 1 database that is replicated between two offices. I'd like
to affix A at the begining of the autonumber of any record entered by our
office here in the US and an E at the begining of any record entered in
Europe. How would you go about doing this?

Thanks
Evan M
evan AT radiologyonesource DOT com


.
I'm no MVP, but as far as I know Autonumber is

Autonumber -- one up long integers, period, Schluss. What
you need is another field that stores either an "A" or
an "E" depending on who creates the record. (You can
always set up a query to concatenate the letter to the
front of the autonumber value if you absolutely need to,
although I can't imagine why that would be necessary.)

However, how is your system going to know who is creating
the record? The easiest road would be to force the user
to select either A or E -- no value, no record save. No
programming needed -- you can set up the basic table
structure to accept only A or E, and can specify that null
values are not acceptable.