Relationship is linked but not interacting

[m3shoess]

Hi everyone,

I have 3 datasets:

1) company name, description, ISIN code and CIQ code

2) Company name, client list, and CIQ Code

3) Company name, ESG grade and ISIN cofe

Company name format is all slightly different so I have built a relationship via CIQ code between 1 and 2, and ISIN code between 1 and 3. No relationship between 2 and 3.

 1 and 2 seems to be interacting fine but 1 and 3 doesnt seem to be interacting with each other. Here you can see if I chose Prudential, it comes up with names but the grade remails as A but it should be B. The I checked ISIN code and they do match...

Help appreciated!

Thanks!

[m3shoess]

I changed the relationship direction to both ways and it is now working! thank you. 

[Mohammad_Refaei]

Most welcome 

[Mohammad_Refaei · Accepted solution]

Your relathionship directions is the reason.

You have ESG Grades -- Filtering --> Company Details -- Filtering --> Contacts.