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 Numbers, again, by Quote Number field.  And the Sold-to is linked to SAP Record by Sold-to field. The relationships travels fine betwen Quote Actuals and Quote Header but not when it tries to travel to Quote Partners from Quote Actuals.  All relationships are bi-directional. Please see screenshots below.

 

 

Need Help

1 Reply

  • 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