Forum Discussion
Solved
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 w...
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
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"