J
JKarchner
I am having trouble linking subforms together. I use the technique with the
invisible text box. So i have it so that the textbox reads the value from
the first subform. then i set the properties of the second subform so that
the master link filed is equal to the name of the textbox, and the child link
field is set to the corresponding field in that subform. however when i got
to view my form in view mode, i get an error saying that it is too complex
and the second subform is not displayed. now i read that in order to use
this method the fields have to be the primary key of the table, but in my DB
the tables i am using for these operations are linking (junction) tables and
thus do not have primary keys. can anyone provide some insight? thank you
very much.
invisible text box. So i have it so that the textbox reads the value from
the first subform. then i set the properties of the second subform so that
the master link filed is equal to the name of the textbox, and the child link
field is set to the corresponding field in that subform. however when i got
to view my form in view mode, i get an error saying that it is too complex
and the second subform is not displayed. now i read that in order to use
this method the fields have to be the primary key of the table, but in my DB
the tables i am using for these operations are linking (junction) tables and
thus do not have primary keys. can anyone provide some insight? thank you
very much.