subform - linked fields

[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

 

[John Vinson]

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

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.