Populate dropdown with values as well as display texts?

[JonathanGibbs]

Can I populate a dropdown's items with value-text pairs, rather than just texts? And then retrieve a numeric Value rather than the displayed text? in other words, emulate

<Select><Option value=1>Item 1</Option><Option Value=2>Item 2</Option><Option Value=3>Item 3</Option></Select>

[jurivera]

Oops!

One more thing:

In the advanced tab of the DropDown, you mest enter the following in the "Value" field:

[jurivera]

One more thing:

You need to add this so that if you come from a selected item in a gallery, you can acctually see the data that comes from the sharpoint list:

DataCardGender_1.Dropdown7_1.Default = Concatenate(Parent.Default, " - ", LookUp(UCA_Gender, GenderID = Parent.Default, GenderDesc))

[aamir]

I dont see a similar Text/Value pair for the items populated from databases. Is there any way to achieve this from a Sql Server Data source?