I'm in the process of creating a new database for quality review.
I have a form called "Quality_Subform" which is basically a whole lot of checkboxes questions.
For each set of question I have the following options:
N/A, C (Correct), NON (Not necessary), ON (Necessary) and FB (Feedback)
I also have a "main" question which is at the top of every "group". This question has 3 options : C (correct), I (incorrect) and FB (feedback).
The first set is not meant to be really use, but to serve as an indicator of what's underneath.
I would like to know if it's possible and how to create a Relationship between the secondary question and the main one.
Essentially here's what I want:
If all the questions are either N/A or C : Main question should be C.
If for ANY of the secondary options "FB" is selected, then in the main one it should switch to FB without regards for the fact that the other ones are correct.
If for ANY of the secondary options "NON" or "ON" is selected, then the main one should switch to I, even if there is one FB and many C.
I've attached an early version of my db so you can help me if possible.
Thanks
(This is just to get an idea of how it should work)
New DB_anon.zip