Auto Numbering - Help!

[MJ]

No one answered my original e-mail--it probably wasn't clear. I am
hoping this makes the question a little clearer.

Is it possible to combine both letters and numbers in an auto number?
I can't make it work past 9--when it comes to 10 it doesn't work. Here
is what I am using for format:
"SP-"&

It numbers SP-01, SP-02, etc. until it should show SP-10, but all I get
is: 1SP-0; 1SP-1; 1SP-2. Any ideas on
how I can get it to keep the 1 and zero together on 10?

[Bas Cost Budde]

MJ wrote:

Is it possible to combine both letters and numbers in an auto number?
No.
"SP-"&

It numbers SP-01, SP-02, etc. until it should show SP-10, but all I get
is: 1SP-0; 1SP-1; 1SP-2. Any ideas on
how I can get it to keep the 1 and zero together on 10?

You can display what you want, an autonumber cannot be edited anyway. So
if you want to display the string "SP-" in front of the autonumber, have
a control with that as its controlsource:
="SP-" & yourautonumberfieldname

Be sure to give the *control* a name other than the *field* otherwise
Access gets confused.
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[MJ]

You are wonderful!!!! I just tried it and it works. Thank you so much
for taking the time to answer. Merry Christmas!

[MJ]

Now my problem is that if the primary key is auto numbering in one
table I can't use it as a foreign number in another table so I can
relate them. Access doesn't allow two fields to be auto number. Do
you know of a way around that?

[Bas Cost Budde]

MJ wrote:

Now my problem is that if the primary key is auto numbering in one
table I can't use it as a foreign number in another table so I can
relate them. Access doesn't allow two fields to be auto number. Do
you know of a way around that?

I don't think you want to go around that. In the other table I expect
you have another field that should be in the primary key too, otherwise
there is little point in having two tables.

What are the tables about?

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[MJ]

One table has Customer Information on it and one has to do with visits
to customers. When I add a new customer or if there was a new visit to
a customer, I didn't want to have to figure out what number to assign
to either table--I thought auto numbering would be the key.

[Rick Brandt]

MJ wrote:

One table has Customer Information on it and one has to do with visits
to customers. When I add a new customer or if there was a new visit
to a customer, I didn't want to have to figure out what number to
assign to either table--I thought auto numbering would be the key.

Both tables can have AutoNumbers as the PK. But you cannot use those to relate
the tables to each other. You need a separate long integer in the Visits table
that is related to the AutoNumber in Customers.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com