'Relationship 'd1259967-03f1a-b4a5-f83344f5d47'; between columns has the TO end cardinality set

[shaherbano]

Hi, i have created a Mapping table with a primary key (all unique values). but as i try to create relationship, i get the error as mentioned in the subject line. Key in MPN_Mapping needs to be connected to Part_clean. Any help appreciated

 

[v-yuta-msft]

Hi shaherbano,

Which relationship are using when you build the relationship between the two tables? Are you building a one-to-many relationship between table MPN_Mapping and table Part_clean based on the [key] column? if it is, you should set 'MPN_Mapping' side as "one" and set 'Part_clean' side as many because MPN_Mapping has a primary key column.

Regards,

Jimmy Tao

[shaherbano]

nothing is working for me. I am working since 2 weeks now on the same problem and not able to move forward. in desperate need to help to find out