Displaying the selected value of a dropdown list

[Rhodri]

Hi, I have set up a dropdown list which is populated by a dynamic list.

The list is based on a web service which returns 2 columns, question_id and question_text, and both are columns are mapped accordingly. The question_id is being written to a database, and the question_text is what is being displayed in the dropdown list.

When the record is retrieved, the question_id field is retrieved correctly, but the dropdown list shows 'Select'. i.e. it does not default to the question_text that corresponds to the question_id.

Can anybody help me make the dropdown show the value was saved to the database when the record is retrieved?
I hope this makes sense to read ...

Many thanks

[Stevenw]

2 options that you can choose to do this,

1. use a view to return the record tha includes the question and map it to the drop down menu.

2. you retrieve the record as normal then perform a second fetch using the table with the questions to get the correct question and map it to the drop-down menu