Hello,
As is explained on the Create Answertype Menupage: in case of SQL
*First two columns of query results will be used as the value and text in the dropdown list
You cannot save two different values at the same time.
Alternatives:
- use the same field for both value and text
- concatenate the text and value fields into the value
select firstname, userid from vts_tbuser
select firstname, firstname from vts_tbuser
select firstname, firstname+convert(varchar,userid) from vts_tbuser