Main report with two "sub forms" problem

  • Thread starter Stephen Jame Pattenden
  • Start date
S

Stephen Jame Pattenden

I have created a form that logs the main part of a Risk Assessment. I then
have two sub forms linked to each main part of the risk assessment - Hazards
and Actions. These two sub forms have one-to-many relationships with the
main Risk Assessment. How can i best represent this data in a report? I
have tried creating a normal type of query but it does not return the correct
data.

Your help would be greatly appreciated!
 
M

Marshall Barton

Stephen Jame Pattenden <Stephen Jame
I have created a form that logs the main part of a Risk Assessment. I then
have two sub forms linked to each main part of the risk assessment - Hazards
and Actions. These two sub forms have one-to-many relationships with the
main Risk Assessment. How can i best represent this data in a report? I
have tried creating a normal type of query but it does not return the correct
data.
Click to expand...


Use subreports in a very similar way to your subform.
 
Top