Forum Discussion
Relationship Workaround
The problem is that the current set up for the model means that if the filter from BRIDGE TABLE -Data Entry propagates around the tables ending at Link Codes for QA. You cannot therefore have an active relationship from BRIDGE TABLE -Data Entry to Link Codes fro QA because it may be in confilct with the propagation.
I suggest you set up the model like this. Make all the relationships One-to-Many and single direction
Hi NJ81858
Active the relationship between table "BRIDGE TABLE-Data Entry" and table "Link Codes for QA" . Then you can through [Entry ID] to filter data between three tables .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It won't let me activate the relationship between "BRIDGE TABLE - Data Entry" and "Link Codes for QA" since there is an active set of indirect relationships between the two tables.
This is the error message that I get when I try to Activate the relationship between "BRIDGE TABLE - Data Entry" and "Link Codes for QA"