Showing multiple many-to-many relationships in a report

[DepricatedZero]

So my DB has a number of many-to-many relationships. Customers can have Multiple Managers and vice versa, Customers can have multiple Resources and Resources can be used by multiple Customers.

I'm trying to build a Report which groups everything under Customer. I have the query built, and when I run it it gives the results I want/expect: a row for each resource and each manager. However, when I go to build the report, I only have options to list managers, no fields from resources. Does that make sense?

The high level view is something like this:
[resources]<-[customers]->[managers]

The Query runs correctly and pulls results from both Resources and Managers based on the Customer
However, the Report of the Query will not show Resources.

I'm new to Reports, so may be something obvious too. Suggestions?

[June7]

Does not make sense to me.

Reports that involve multiple 'many' tables often work best with subreport(s).

If you want to provide db for analysis, follow instructions at bottom of my post.

[orange]

Please post a jpg of your relationships.

[DepricatedZero]

Does not make sense to me.

Reports that involve multiple 'many' tables often work best with subreport(s).

If you want to provide db for analysis, follow instructions at bottom of my post.

Actually that may be just what I needed. I'm not familiar with Reports, really - this is my first time delving into them. I figure I have this great tool though, so why not use it. Sub-Reports sound about right, probably exactly what I need, so I'll look into those and come back with a screenshot of my relationship structure if that doesn't help. But it sounds spot on.

Yep! As I siad, it could be something obvious. I just needed Subreports, I didn't even know those were a thing, and my google searches weren't bringing them up since I was using query terms.