Problem with Report - Many to Many

[Novice1]

I'm building a report where I want to show all the MissingItem (tblMissingItems) on for each person in tbleOutbounds (see atch relationships). I don't know how to link the report and subreport.

I tried ReloID from tblOutbounds with ReloID in tblMissingJunction, which works but if there are 5 missing items then the person is listed five times.

I tried other links without success. How should I link the report and subreport. Any help would be appreciated.

 

[Ranman256]

Do it all in the query, join the main to sub table.
Then the report can have all the data. No sub report needed.

 

[Novice1]

Thanks ... you got me thinking. The solution is to create two groups. Thank you very much!!