Cardinality Direction Reversed - December 2020

[atacuboy]

Hi,

Wondering if any of you encountered this issue - the cardinality directions in my file were reversed - for example, one-to-many became many-to-one, even though the model arrow direction shows the correct cardinality (one-to-many).  I encountered this just last month.  I did not do anything to change the file, it's just that when I opened it, the relationships were all messed up.

I tried editing the direction (from, to), but it's not accepting my changes.  It just reverts back to the incorrect direction.

Now I cannot refresh my reference table because the original setup was one-to-many, so since it's locked to many-to-one, I am encountering the error related to duplicate values not being applicable.

Thank you

[amitchandak · Accepted solution]

@atacuboy , Just check for blank value or non unique value on one side. If it flipped, then there should be some reason .

In this video, it happened, when I had the wrong data - https://youtu.be/MPYfEetvFH4?t=361

[atacuboy]

Thanks for the response!