Forum Discussion
PBI_Inquisitor
Advocate I
Advocate ICan'r create a Direct Active Relationship
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 - th...
PBI_Inquisitor , This may be because of bi-direction joins
Make all One -Many join as single direction
amitchandak
Super User
Super UserPBI_Inquisitor , This may be because of bi-direction joins
Make all One -Many join as single direction
PBI_InquisitorAdvocate I
Advocate IThanks Amitchandak - seems to have done the trick - swapped around each relationship as well eg Emp - DT1; Emp to DT2.
Kind regards, Phil