Sum of values from a check box set.
I am new to DB and FM pro. I am trying to insert in my DB risk scores for cardiovascular disease. The best way would be with a set of check boxes containing risk factors (let's say: hypertension, smoking, etc.). I need to assign a value (mostly positive, like 1 or 2 points, but eventually negative like -3) for each risk factor (box), an then create a field containing the result, wich is the sum of all numbers corresponding to the checked boxes.
Can anyone help me with this?