I have a page with a radio buttons on with options of yes or no. There is a submit button under it all in a form. This is what I would like to do:
IF Yes (radio button selected) then
update 3 fields in the database to 'No'
and update another in the same record to 'Yes'
IF No (radio button selected) then
update 3 fields in the database to 'N/A'
and update another in the same record to 'No'
Is this possible and I have brought over the recordID from the previous page to ensure we are talking about the same record...otherwise I suppose we would be ammending random records!!
(Also please note that the Yes/No radio button group is conditional based on the field in the database...meaning, if it says Yes, then the radio button will be yes.
Hope you can help/know what I am babbling on about!!