J
JKarchner
I have looked through the discussion groups and was unable to find an answer
to this question. Can i link 2 subforms together? I have seen examples
where you can link 2 together and the second one depends on the which record
is selected in the first. What i need is that the information in the second
subform depends on all the data in the first subform. That is all the
records from the first subform are used to show the all records in the second
subform.
To give you more background on the situation: I have 3 tables and they are
Models, Engines, and Suppliers. Now i have 2 linking tables:
EnginesXREFSuppliers and ModelsXREFEngines. So this means that every Model
can have more than one Engine and every Engine can be in more than one Model.
The same applies to the Engines and the Suppliers. The main form displays
the Model. The first subform shows the Engines in that Model with supply
percentages. I would like for the second subform to display the Engines with
the Suppliers.
I have tried to create queries for to solve this problem, but all of the
queries are do not allow for updates, and i figured that linking the subforms
might be the easiest way around this problem. I am open to any suggestions
you might have. Thank you very much.
to this question. Can i link 2 subforms together? I have seen examples
where you can link 2 together and the second one depends on the which record
is selected in the first. What i need is that the information in the second
subform depends on all the data in the first subform. That is all the
records from the first subform are used to show the all records in the second
subform.
To give you more background on the situation: I have 3 tables and they are
Models, Engines, and Suppliers. Now i have 2 linking tables:
EnginesXREFSuppliers and ModelsXREFEngines. So this means that every Model
can have more than one Engine and every Engine can be in more than one Model.
The same applies to the Engines and the Suppliers. The main form displays
the Model. The first subform shows the Engines in that Model with supply
percentages. I would like for the second subform to display the Engines with
the Suppliers.
I have tried to create queries for to solve this problem, but all of the
queries are do not allow for updates, and i figured that linking the subforms
might be the easiest way around this problem. I am open to any suggestions
you might have. Thank you very much.