I would need to display a certain result in a field depending on what the user selects.
Say, for eg, there are 3 fields.
Field 1 choices: 1, 2, 3
Field 2 choices: 1, 2, 3
Field 3 choices: 1, 2, 3
I'll need to display field 4 results according to what the user selects in field 1 to field 3.
Field 4 choices is: Low, moderate, high.
When the user selects a total of 3 points from field 1 to 3, field 4 shows Low.
When the user selects a total of 4-6 points from field 1 to 3, field 4 shows Moderate.
When the user selects a total of 7-9 points from field 1 to 3, field 4 shows High.
How can I complete the query?