Report Out of Control - Will Not Junction

[Guest]

I am trying to produce a report that lists buildings by name and the related
architects. Some buildings have more than one related architect. I built
and populated a junction table BuildingArchitect with primary keys from
tables: BuildingName and Architects. The report will not list multiple
architects under one building. Instead it lists the building again with the
second architect. What I want would be similar to the Northwind Invoice
where one Order (Building) lists many Products (Architects). I tried adding
a subreport/form that works well for this as a form, but it only shows for
the first record in the report.

Thanks for helping.

 

[Duane Hookom]

You shouldn't need a subreport for this. Make sure you group by Building
Name and display the header. Add the fields from the building table to the
building name header.