Forum Discussion
Create a direct active relationship
Hello Community, I am unable to create a relationship between these two tables. Please help.
Hi, Anonymous ;
You could
Since a closed-loop relationship cannot be formed when the relationship is created, you can see in your picture that you have a closed-loop relationship, so the last relationship of the closed-loop cannot be activated. If you want to activate it, you need not to activate another one. I tested a simple example,
Because if all three of your relationships (which I marked) are in effect, then there will be a logical conflict and there will be no way to tell which side of the relationship I should quote. So the solution is not to activate one of them, and write the measure with USERELATIONSHIP()
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- v-yalanwu-msftCommunity Support
Hi, Anonymous ;
You could
Since a closed-loop relationship cannot be formed when the relationship is created, you can see in your picture that you have a closed-loop relationship, so the last relationship of the closed-loop cannot be activated. If you want to activate it, you need not to activate another one. I tested a simple example,
Because if all three of your relationships (which I marked) are in effect, then there will be a logical conflict and there will be no way to tell which side of the relationship I should quote. So the solution is not to activate one of them, and write the measure with USERELATIONSHIP()
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - AnonymousNot applicable
Thank you v-yalanwu-msft