Is there any way to show an embedded report with all the records related through a summary table
There are three relevant tables in this scenario, Projects, Groups, and a summary table called Project Groups. There is a one to many relationship from Projects and from Groups to the Project Groups ...
This should do it
In the Project table make a Summary Field to get the Related Group from the Project Groups Table
Add a Report Link Field to the Projects table
Configure the Report Link field so that the target table is Project Groups
Set the Summary Field Related Group is equal to Related Group
Then you can create a report in the Project Groups table to use as the Embed for the Report Link field.
