Forum Discussion
Helper ICan't determine relationships between the fields
i have 3 tables all having numeric key ID. Sample of each table below.
Main
ID
Name
Date
TIme
Action:
ID
Action Item
Reponsibility:
ID
Responsible item
Not all records in table Main will have an associated record in either table Action or table Responisbility
Have created a simple one to many relationship between ID fields:
Main to Action
Main to Responsibility
When i create my report i can add fields from Main and Action tables and Main and Responsibility tables OK
But if i add fields from all 3 tables i get the "Can't determine relationships between the fields" . Nort sure what to do here.
Just want to display any record in Main that has any related record in both Action and Responsibility
thanks
cheezy
For example, if the Main to Action is both direction, when have all 3 tables in a visual, the Responsibility table value cannot determine whether the filter context is from main table to action table. Just make both relationship to single direction, Main => Action, Main =>Responsibility.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
