Relation issue

[nbaudry]

Dear Forum,
Since a couple of days, I am dealing with an issue of relation table.
I have 5 tables:
- Calendar
- Project information
- Load of the projects
- Capacity of the project manager
- Project manager table
I need to analyze the load/capacity of the project manager sort by priority.
My issue in the summary tab I see also the project of Pierre but he hasn’t any project in priority 2.
Many thanks for your help
N.