Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Manage relationship From Table and To Table order changes after creating relationship

Should the order of the "From: Table (Column)" to the "To: Table (Column)" in the Manage Relationships change?

 

I manually create a relationship between two tables.  Here's how it looks

 

Here is how it looks after I press ok. The From Table is from 'Quick Ship' and the To is 'Global Sales' (this is what I want)

 

 

 

 

 

I press ok and then reopen the relationship and the order in the from and to has now switched (it now goes from 'Global Sales' to 'Quick Ship' which is backwards to what I want). Why is this happening and can I fix it? It seems to be creating a problem in a visual for me.

 

 

  • Hi Anonymous 

    Don't worry, as tested, i find the same with you.

    It doesn't change the relationship we created before.

    Maybe when opening the "manage relationship" UI, it would show relationships in "many to one" direction by default.

     

    Best Regards

    Maggie

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous 

    Don't worry, as tested, i find the same with you.

    It doesn't change the relationship we created before.

    Maybe when opening the "manage relationship" UI, it would show relationships in "many to one" direction by default.

     

    Best Regards

    Maggie

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous 

    Is this problem sloved? 
    If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?
    If not, please feel free to let me know.
     
    Best Regards
    Maggie