Parent-child Report Format

  • Thread starter Thread starter Patrick Page
  • Start date Start date
P

Patrick Page

I need to produce a report in which the parent information is in columnar
format and the children's info is tabular. Can I do this with the Report
Design Wizard? What is the recommended technique? TIA for any help!
 
Patrick,

If you make a query that includes the "parent" and "child" tables, and
base your report on this query, and then put in a Group Header section
in the report on the ID of the "parent" data, and put the
"parent"-related controls in this header section, and the
"child"-related controls in the Detail section, I think it will pretty
much give what you want. Some people might use a report/subreport
design, but in practice this is seldom necessary.

If you need more explicit help with this, maybe you can post back with
more details of your data, with examples, and a description of how you
want the report.
 
Back
Top