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.
Not to my knowledge. This issue and the parent child fields stuff in
subforms is why I switched from using multi field primary keys to
autonumber primary keys.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages -
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -
http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see
http://www.autofeupdater.com/
Granite Fleet Manager
http://www.granitefleet.com/