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

Sorry, I mistakenly posted this in Word instead of Access Forum.

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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Richard" <(E-Mail Removed)> wrote in message
news2A75283-B69A-441B-A485-(E-Mail Removed)...
> Sorry, I mistakenly posted this in Word instead of Access Forum.

<g>

--
Stefan Blom
Microsoft Word MVP


"Suzanne S. Barnhill" wrote:

> 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
> Word MVP FAQ site: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so
> all may benefit.
>
> "Richard" <(E-Mail Removed)> wrote in message
> news2A75283-B69A-441B-A485-(E-Mail Removed)...
> > Sorry, I mistakenly posted this in Word instead of Access Forum.
>
>