Problem with RADIO GROUP, How to save the values

HI there,

I have a table named "QUESTION" with columns (Q-ID, Q_temp_total, Q_total)

I have a FORM, with a list of questions (10 questions) ,each question, has 3 RADIO Buttons (with values 1, 2, 3) .The User has to select one of the Radio buttons for each Question.
That value has to be saved into the Question table, at Q-ID (the question number -from 1 untill 10), the value choosed from the Radio Button, has to be putted into the Q_temp_total column, where the Q-total, is going to hold all the values choosed by the User, divided by the number of Users for each question.

I created the Radio Group as DB item, and I gave the Null initiall value, and for the Radio buttons (values 1, 2 and 3)

At the end of the form, I have a SAVE button, for saving the changes.

Do I have to put the Trigger WHEN-RADIO-CHANGED at the Radio button(s)?IF YES, which statement I have to put inside that Trigger (or just an empty Trigger)?

Next, at the SAVE button, do I have to put inside the trigger WHEN-BUTTON-PRESSED, the statement COMMIT;

When the SAVE button is pressed, I need first to check, if the User did checked all the questions, If not, Alert tellin him, which question he didnt check.
If all questions checked, I need to save the Radio button value of each question, into the Question table, e.g. for question 1 (Q_ID=1, Q_Temp_Total=X, Q_Total=X).

I did, something like this, but it refuses to INSERT the record into the DB .

One more thing: the table QUESTION, has a foreign key (Q_ID)) within another table (Evaluate) with the column Eva_Q_ID.

I tried to do insert all the 10 questions into the QUESTION table, but it didnt accept to insert the records!!????
Is that, because of the Relation with the EVALUATE table?


I hope you got my problem.
Please try to help me, as I'm stucked at this problem.

If it wasnt clear, pls let me know.

THnx in advance,

Alban