Hi All

I was wondering whether someone can help me with the following problem with regards to building relationships between tables in Power Pivot:
I have 4 tables in my Power Pivot which has been created from other workbooks.
My tables are called:
Employee – which Contains Unique Id numbers and name of Employees
Site Names: Which Contains unique Dept Numbers and the Divisions which those departments belong too
Scores: Which has Department Numbers and scores for each department in each week (none of the fields are unique here as the a department can have multiple scores throughout the year)
Eligibility List: Which contains list of all employees and the departments which they are responsible for (again two employees may be responsible for multiple departments and none of the fields are unique).
What I need to do is to create a relationship between my tables to achieve the following:
Get the Dept Numbers from Site Names, Employee Ids from Employee, Score from Scores and employee names from Eligibility List.
Currently I have the following relationship set up

Relations.PNG


However what I cannot do is somehow build a relationship between scores, employee and eligibility list. I don’t mind creating another table but not sure what I need to do to have site from Site Name , Employee ID and Name from eligibility List and score from Scores.
Any help is appreciate it. I hope I am clear in what I need to Achieve.

Thanks