Concatinating one PK from one tbl & autonumber for a PK in another

G

Guest

I have many tables based on two fields in two different tables. Rather than
have both PKs in every table, I would like to have a PK from one table
(tblStyle SK (StyleKey) 1...50) be in combination with an autonumber giving
me a unique ID based on the two so that it looks like this:

tblDesign Primary Key = (SK)37+autonumber = 37405

If this is possible in Access, would you please explain how I would go about
doing this? Thank you
 
S

Suzanne S. Barnhill

Whew! That's a relief. I was afraid I'd been totally missing something in
Word!

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
G

Guest

<g>

--
Stefan Blom
Microsoft Word MVP


Suzanne S. Barnhill said:
Whew! That's a relief. I was afraid I'd been totally missing something in
Word!

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatinating one PK from one tbl & autonumber for a PK in a 2nd t 7
Separate PK in Jxn Tbl? 168
Using Autonumber as PK? 4
Many to Many with AutoNumber PK 4
Questionnaires PK & Tables 5
autonumber PK scrolling problem 6
Generating a PK with autonumber- FRUSTRATION! 7
Using Autonumber as PK, cascade update doesn't work? 17

Top