I've completely run out of ideas for how to make this work. Can anyone help?

I have a One-to-Many situation where one Parent record relates to many child records, but the child records reside in three different child tables.

What I'm trying to do is print a report that shows the Parent in the header, and THREE detail sections, one for each of the three tables involved. Something like this ....

MyParent Header
-- parent data line
-- parent data line

Child Table 1
-- data from child record 1
-- data from child record 2
-- data from child record 3
-- data from child record 4
-- data from child record 5

Child Table 2
-- data from child record 1
-- data from child record 2

Child Table 3
-- data from child record 1
-- data from child record 2
-- data from child record 3
-- data from child record 4
-- data from child record 5
-- data from child record 6
-- data from child record 7

I know how to do this when there's only ONE child table involved, but HOW DO YOU GET DETAILS WHEN MULTIPLE CHILD TABLES ARE INVOLVED?!? Is this even doable?

I could really use some help here. Surely I'm not the first.

Thanks a lot.