| 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 |
| 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 | |||
Threaded Mode