Master/Detail

[JoeCL]

Hello!

How can you make a subform when three fields make up the
relationship between the two tables. These are the fields:

Dept_Code, Year, Quarter

The manuals and other reference materials only involve on
field relationship. Thanks

 

[Allen Browne]

1. Open the main form in design view.

2. Right-click the edge of the subform control, and choose Properties.

3. Set the LinkMasterFields property to
[Dept_Code];[Year];[Quarter]
and similarly for the LinkChildFields.

Note that there is a Year() function in VBA, so the field name may cause you
grief.

 

[Larry Linson]

The LinkMasterFields and LinkChildFields properties of the Subform/Subreport
Control allow specifying multiple fields. They are separated either by
commas or semicolons, and clicking F1 for Help while in that field should
tell you which.

Larry Linson
Microsoft Access MVP