I have a form with combo box control using SQL driven Question Option. The SQL stament basically populates combo box with all registered DNN users and also retrieves all corresponding emails (select displayname as QuestionOption, email as QuestionOptionValue xxxxxx).
What is the recommended way to pass the QuestionOptionValue (email address) to another control (for example a label or read-only text box) as well as to an email event generated upon submitting the form?
Thanks!
Jake