Forum Discussion

LydiaMitchell's avatar
LydiaMitchell
Qrew Member
2 years ago

Only show parent records as an option based on answer to a field

I have a 4 tables; Testing Procedures, Requirements, Compliances, Applicabilities.  Each Requirement has multiple Testing Procedures. Each Requirement has a Compliance. The last tabel Applicabiliti...
DonLarson's avatar
DonLarson
Qrew Commander
2 years ago

It does not sound like you have enough tables or the relationships.   If I am following you then you need seven tables

Three tables have all User, all Compliance Objects, all Test Procedures

You then build Requirements for each Compliance Object and the Test Procedures for each Requirement

Users pick their Requirements and that determines the User Test Procedures.  It would look like this:



------------------------------
Don Larson
------------------------------