Forum Discussion

danextian's avatar
danextian
Icon for Super User rankSuper User
9 years ago

Bi-directional relationship not working as expected

Hi All,   I'm trying to figure out and fix relationships betweent data tables. I have Quote Actuals table that is linked to Quote Header by Quote Number field. The Quote Header is linked to Quote N...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi danextian,

 

Since there is a one to many relationship between Quote Actuals table and Quote Header, also, the Quote Header is linked to Quote Partners with a one to many relationship. So, there existing an indirect many to many relationship between Quote Actuals and Quote Partners. That is why it failed to travel to Quote Partners from Quote Actuals, as a record row cannot determine the mapping rows in another table. You could not add both Quote Number columns from Quote Partners and Quote Actuals into a single table visual.

 

Best regards,
Yuliana Gu