Error - Can't Determine relationships between the fields.

[kapilnath]

I have 3 tables , Team Details, Training and Review . Joining Team ID with Training ID and Team ID with ID in Review Table. 

Now I build report  using these 3 tables get the error.

[kapilnath]

Even both directions , still I get same error.

[Idrissshatila]

Hello @kapilnath ,

So i suppose you're viewing the data through a field from a table that is against the filter path. In the data Model you can see the relationship lines between the tables and there is an arrow on the line between these two tables that means that the table behind the arrow can filter the table infront of the arrow and not vice versa.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡