I have a report that has one subreport attached to it, but will eventually have two more. It runs fine but the subreport data is not displaying the way I need.

My equipment is the on the main report and the subreport is displaying multiple specifications on that equipment (one-to-many relationship). The problem is when I run the report I choose multiple equipment's at a time for the main report and each equipment is on its own page, however, the subreport is displaying all the specification records for each equipment. It isn't filtering and only showing the specs for the equipment on the main report. Is it possible to do this with a subreport?

I am using two different datasets. One for the main report and one for the subreport. Is there a way to link/join the subreport to the main report so the subreport only displays the data corresponding to the main report record? I have a equipmentID primary key in my main table and that field is also in the specs table.

Hope that makes sense.

Thanks,
Stacy