View Single Post
  #1  
Old January 18th, 2010, 08:44 PM posted to microsoft.public.access.tablesdbdesign
Steve S
external usenet poster
 
Posts: 162
Default Multi-field Primary keys

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.
--
Steve S