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

R

Richard

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!
 

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? 144
Using Autonumber as PK? 4
Questionnaires PK & Tables 5
autonumber PK scrolling problem 6
Child Table With Two Parent Tables 4
Fixing up field with a row number to become PK 1
ODBC and PK 1

Top