For your two questions I would solve it this way
For Q1 the Employee Report Link in the Regions table would be looking for the Employees where the Related Locations are the same. It is not a direct relationship between the data but each record in the Region Table will have a report of all the Employees at that location
For Q2
You can get both User fields into the Project Employees table. Your reports from there can use an "Any" filter to let either the Employee or the Manager see the records based upon being the Current User.
Yeah we don't have a regions table because the combinations could be infinite so we're doing it on a manager level
ie. Manager A on Project A could be responsible for a region that is Spain and France
but Manager B on Project A could be responsible for a region that is Spain, France and England, so neither the manager or the proejct dictate the region exclusively there is overlap where things are inconsistent.
Ideally i'm looking for a way to either utilize a checkbox formula or a formulaquery that will say if an Employee's location (Multiple Choice) is included in a Manager's region (Multi-Select) then show that employee on the report without having to have the manager select a filter.
Setting the report filter as Employee's Assigned manager contains <<Current User>> AND Manager's Region includes employee's location.
