Can'r create a Direct Active Relationship

[PBI_Inquisitor]

Hi

I have a number of different data tables [DT1:DT7] which have a relationship to a single employee table [Emp} so that I can pick an employee from [Emp} and it will filter all seven tables - this is working fine

I now have an 8th data table that I also want to create a relationship to [Emp] but it is saying I cannot as would introduce ambiguity between Emp & DT3

I can't see why this works on the other DTs but not DT8

This explains the relationships that are already working:

DT1 Employee_SID Relates to Emp EmpID

DT2 UserID Relates to Emp EmpID

DT3 Employee_SID Relates to Emp EmpID

DT4 OwnerID Relates to Emp EmpID

DT5 Emp_ID Relates to Emp EmpID

DT6 Owned_BYID Relates to Emp EmpID

DT7 ChngdByID Relates to Emp EmpID

And the one that is now causing the issue

DT8 CreatedBYID Relates to Emp EmpID

Thanks in advance for any advice

[amitchandak · Accepted solution]

@PBI_Inquisitor , This may be because of bi-direction joins

Make all One -Many join as single direction

[PBI_Inquisitor]

Thanks Amitchandak - seems to have done the trick - swapped around each relationship as well eg Emp - DT1; Emp to DT2. 

Kind regards, Phil