Relationship Workaround

[NJ81858]

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

[PaulDBrown · Accepted solution]

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

[v-yetao1-msft]

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.

[NJ81858]

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.

[NJ81858]

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"