I spent all day yesterday trying to figure this out. Any help will be much appreciated.

I have one parent table and 11 child tables. (My app uses parameterized views rather than related tables, but I'm willing to relate the tables to get the report to work.) I want to produce a report that shows the parent table info at top, then the child table info from each of the tables like this:

Parent record1 field1, field2, etc.

Child1 Record 1 ...
Child1 record 2 ...
etc.

child2 record 1 ...
child2 record 2 ...
child3 record 3 ...
etc.

child3 etc

Not every child table has a record, so I guess I need to do left joins in a SELECT statement. But no combination of SELECTs and data groupings I could think of produced the correct results. Is there a basic strategy for accomplishing this?