How to link more than 3 fields to a subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a subform for the main one,
but there are 4 fields that form the key, but while
creating the subform to the form, it allows me to
link only three. Is there any way I can add the
4th field?

Thank you,
-Me
 
I assume you're talking about the Link Child/Master Fields properties of the
Subform Control object. Since the combination of the 4 fields will be
unique, you could create a calculated field in the query that feeds each
form. This calculated field would be a concatenation of the 4 fields that
make up the key. You would then use this field as the linking field.

The Help file doesn't give a limit to the number of fields, but there
probably is one. Judging from you're question, I'm guessing that the number
is 3.

Questions: Were you using a Wizard to create the subform? If so, was this
limit of 3 in the Wizard? Have you tried placing the entry directly in the
properties dialog of the subform control yourself?
 
Back
Top