Greetings All,

I'm a little stuck on the correct SQL statement to update a field that is based on radio(option) buttons. If the two options of the radio buttons are PREMIUM or ENHANCED, how would I write a sql statement that would allow me to write the selection to a table?

Thanks so much for looking.

HI, you do it the same way you would any other field. Let's say your SQL table is:

tblRadio(ID,answer)

where ID is an auto-generated identifier and answer is an nvarchar(10) to hold value of 'PREMIUM' or 'ENHANCED'.

In your Dynamic Forms SQL Completion Event, type in your insert statement there:

insert into tblRadio(answer) values('$(radiofield)')

but replace the "radiofield" name with the shortname on your form. -- David