subform - linked fields

  • Thread starter Thread starter grace
  • Start date Start date
G

grace

Does Access limit you to only link 3 child/master fields
to a subform? I have a continuous subform that lists a
series of records and I want six fields to link to the
subform. Can this be done?

Thanks, Grace
 
Does Access limit you to only link 3 child/master fields
to a subform? I have a continuous subform that lists a
series of records and I want six fields to link to the
subform. Can this be done?

Thanks, Grace
Click to expand...

I believe that the limit is ten fields - but with six, you might want
to consider having a "surrogate key" such as an Autonumber linked to a
long integer, just for performance.

You may need to manually enter the fields in the Master Link Field and
Child Link Field, it may be that these fields can handle ten but the
wizards can only do three.
 
Back
Top