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