Forum Discussion
Userelationship connection causes multiplied values
I have two tables: 1. Connections (information on connected person, time etc.) 2. Message Classification (Unique messages sent) Now I want to see all connections, that don't have a message y...
Due to some other relationships I can only use an inactive relationship and make use of the USERELATIONSHIP Function.
That's not what USERELATIONSHIP is for. Its main purpose is to switch connections between two tables. Let's say from the Calendar Date to either the Order Date or the Ship Date. Yes, you can use it to "switch on/off" a single relationship but ONLY if switching that on will not result in a circular reference/path ambiguity. Which is most likely what happens in your scenario, leading to the cartesian result.