Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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-msft's avatar
    v-yalanwu-msft
    Community 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.