View Single Post
  #5  
Old January 19th, 2010, 12:19 PM posted to microsoft.public.access.tablesdbdesign
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Multi-field Primary keys

You can set the three fields together as a unique index without using them
collectively as the primary key. This may be old news, but I haven't seen it
mentioned in this thread, so I am pointing it out.

Steve S wrote:
Have several tables where the primary key consists of 3 individual fields.
Is there a way to fererence these fields as a group? Right now I have to
reference FLD1, FLD2 and fFLD3. It would be nice to just have to code
"TBL1.FLDs123=TBL4.FLDS123" instead of "TBL1.FLD1=TBL4.FLD1,,,,etc.

If this issue is addressed somewhere in this newsgroup I just missed it or
didn't recognize it. Sorry.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201001/1