Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Viewing Blanks In Indirect Many To Many Relationship

I have an ERD of items (CI_Item) that are contained both in Sales Orders and Purchase Orders, essentially linking them through an item code, creating an indirect many to many relationship (which is e...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    From the diagram you provided, the relationships are one-to-many and not many-to-many which is how they are supposed to be. I believe your problem is not with the relationships but with the "Filter Direction". You should change the "Filter Direction" to One and then make sure the fields in the visual are set to "Show items with no data":

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

From the diagram you provided, the relationships are one-to-many and not many-to-many which is how they are supposed to be. I believe your problem is not with the relationships but with the "Filter Direction". You should change the "Filter Direction" to One and then make sure the fields in the visual are set to "Show items with no data":

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks! It looks like that "Show items with no data" has resolved it. I did not have that checked on the PO field in my visual.