Multiple lists in one report

[lonesomejubilee]

Hi.

I have a couple of different tables which have lists of items (records). I want to create one mega-report as a month ending summary. I am probably going to script the find that will return the period of time I want. But how do I make that happen for 5 separate sub-reports and then combine all those one-month results into one?

I figured at first I could portal-it into a new layout but in order to do that I'd have to somehow create a relationship to a central table (which one doesn't exist).

In MS Access I just inserted the sub-report, but I'm new to FM so I don't have a clue how to do it.

Thanks.