Use a SQL SELECT statement to join the two tables into one, and then use report banding to group by the fields you want to trigger new pages or new groupings.


>Considering how long I have been writing exclusively in FoxPro, it's kind of amazing how little I know about using the Report Designer.
>
>I have what I consider to be a rather simple problem that I do not know how to resolve.
>
>I am printing a report for a parent record with its child records. The parent record occupies the top 2/3 of a page. The child records follow, one per line. There is room for about a dozen child records on the page. 90% of the time, everything fits one one page.
>
>In the remaining cases, though, where there are lots of child records, using only the bottom 1/3 of a page for the child records, I create a lot of wasted pages, as the parent record gets printed at the top of each page.
>
>What I would like to have is that starting with page 2, only the first few fields (top two inches) of the parent record are printed, so that the there is plenty of room for all the child records.
>
>How do I go about doing this?
>
>Thanks