Inserting Dynamic Menu into a DB

Hello,
I have a dynamic drop down menu. It works fine. My problem is when I insert the values of the form fields into the DB table, it inserts the primary key ID no. instead of the form field name that was displayed which I would like inserted. Please anyone know how I can convert the values from ID to the form field name when inserting the records into the table? I have edited the insert record server behavior values but to no avail. When I get the values from the recordset, it inserts the field correctly, but then, the Dynamic Dropdown Menu would not work any more.
Thanks.
Also, btw, your new upgrades for the CS5 are working surprisingly great. I have not had the dreaded freezing issues and cache error since upgrade. I can't believe I can use your extensions for hours on end without having to delete DW caches and so on. Great improvement--now I think I am getting good value for my money--or maybe it was DW CS4 all along. Anyway, keep up the good work!

To make it so that you are inserting the name rather than the id you will need to add in another recordset to the page. The recordset will have to filter results from the table that is used to populate this particular select list.

The steps are to open the page and add a new recordset, select the table that is populating this particular dropdown menu. At the bottom of the interface use the filtering options to filter on the id column with a form variable, then enter the name of your dropdown list that you are getting the id from.

Once you have the recordset on your page you can then update the insert server behavior to make use the column from this recordset for the name rather than inserting the posted value from the dropdown.

Thanks Eric. That worked great!

Glad to hear that, let us know if you have any other questions.

Hi There,

I'm experiencing the same problem, but not quite understanding the explanation. Can you explain this in lamings terms please?

Regards

Graham

the form passes the id values.


to get the name, you need to create a recordset.


make note of the name of the form element.

then create a recordset.


in the filtering section, select the ID column. set the type of filtering to form element, then enter the form elements name.