Forum Discussion
Relationship Workaround
I just need to know if there is a workaround to join these three tables together. All of the relationships that need to happen are marked in blue. I have tried to make Bridge Tables but that didn't work for me, at least the way that I tried to do it. Thank you in advance
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
4 Replies
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"
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
