Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Proud to be a Super User!
Paul on Linkedin.
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
Proud to be a Super User!
Paul on Linkedin.
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"