| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Concatinating one PK from one tbl & autonumber for a PK in another
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 |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Concatinating one PK from one tbl & autonumber for a PK in another
Sorry, I mistakenly posted this in Word instead of Access Forum.
|
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Concatinating one PK from one tbl & autonumber for a PK in another
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" wrote in message news  Sorry, I mistakenly posted this in Word instead of Access Forum. |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Concatinating one PK from one tbl & autonumber for a PK in ano
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" wrote in message news Sorry, I mistakenly posted this in Word instead of Access Forum. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I convert autonumber to text? | Microsoft Word Help | |||
| Format autonumber and set it as default? | Microsoft Word Help | |||
| Linking to an autonumber | Microsoft Word Help | |||
| possible to have a linked autonumber field? | Microsoft Word Help | |||
| Can I autonumber in increments of ten? | Microsoft Word Help | |||
Linear Mode
