limit to Master~Child link fields

[tecas]

I have a form - subform that has a total of 8 link fields and am
recieving the error message that states expression is too complex. Is
there a limit to the number of fields that you can link between Master
and Child form/subform or report/subreport?

 

[George Nicholson]

Don't know the answer, but assuming both forms are based on queries, just
add a field to both queries that concatenates the 8+ fields, then use that
single field as your link.

HTH,

 

[John W. Vinson]

I have a form - subform that has a total of 8 link fields and am
recieving the error message that states expression is too complex. Is
there a limit to the number of fields that you can link between Master
and Child form/subform or report/subreport?

The limit to joining fields is 10 - the "Expression Too Complex" message
shouldn't be related to this issue. I suspect that it instead has to do with a
complex criterion on your query. Care to post the SQL of the query?

I have to disagree with George on the idea of concatenating fields.
Concatenating "1" with "32" and "13" with "2" will give you an invalid link,
"132" either way, just for one thing.

John W. Vinson [MVP]

 

[George Nicholson]

well, i would have concatenated 0001 & 0032 or 0013 & 0002 to avoid that,
but i didn't warn against that, did I?