Multi-field Primary keys
On Mon, 18 Jan 2010 12:44:01 -0800, 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.
I'll have to (partially) agree with Sylvain and Tony - in that they're right,
there is no way to shortcut this syntax. But I still *very occasionally* use
multifield keys (when there's good reason to use cascade updates and the
fields are otherwise a good candidate key).
--
John W. Vinson [MVP]
|