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.
Ernie Veniegas
Micro System Solutions
... sensible software by design