Forum Discussion
Relationship Workaround
- 4 years ago
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
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