Printing info from related tables

[Wes Peters]

I'm wanting to print a report that shows the rooms of a house and the HVAC
equipment that's installed. The report will be for a single address.

There are four tables: the properties, rooms, AC units, heaters. The rooms,
AC units, and heaters are related to the property table on an ID field.
There can be multiple records for one property in each of the joined tables.
I want to list some property information, then list the rooms (with some
additional info), then the AC units, then the heaters.

I'm using a view as the record source.

I can't seem to get it to print right. I've tried grouping but I get
repetition that I don't want. What's the correct way to format a report to
do this? Is it possible or do I need to break it into multiple reports?

Thanks,
Wes

 

[Wes Peters]

Nevermind - I knew it was something simple -- subreports.
I'll try to keep up.