how to get the relationship working between three tables

[henkka]

Hi, I have a table set as show below.  I'm trying to create a table visual where there is Employee name and the employment mode. For some reason I can't get the values to show. I have tried also to set both relations Employees-Workagreementt and Workagreement-Workagreementmode directions to both but still not getting the values. Can someone please help  what should be done here? 

[henkka · Accepted solution]

Hi, This issue was resolved by removing and recreating relationships. So I assume there was somekind of corrution happened

[v-shex-msft]

Hi @henkka,

Can you please share some more detailed information about these They will help us clarify your scenario and test?

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[RJOttenheim]

Do all your tables have data ?

If so try building your visual slowly

Use a simple visual and take employeeId

Does it show data ?

If so add a field from fw_work_agreement

Does it show data ?

If so ... and so on.

Try to pinpoint where it goes wrong.

Good luck