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

[Anonymous]

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.

[v-juanli-msft]

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

[v-juanli-msft · Accepted solution]

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.