Expand my Community achievements bar.

Combo Box Question

Avatar

Level 1

I have a SQL statement that brings back two fields - ID and Name.  The combo box is bind with the Name fields.  Upon the user selection How can I pull the ID field.

Newbie...

1 Reply

Avatar

Former Community Member

Have you bound the ID values to another object as you bound the Name values to a dropdown list?

If not, perhaps you could bind the ID values to a list box or a dropdown list, and make the list box or dropdown list hidden so it does not render in the form. When a Name is chosen from the dropdown list, you could extract the ID from the list box or dropdown list based upon its relative position, given an ID exists for each Name and a Name exists for each ID.

Steve