Database to DropDown not working

Hi Bob,
I have a drop down box in a form which is pre-filled from a database.
I have entered {com.PaymentPreference} in "selected Values".
According to the database it has "3" entered in the "PaymentPreference"

Options:
=
0=PayPal/Credit Card
1=CC/Cash on Delivery
2=CC/Cash on Pickup
3=Account

But 0 is always selected and not "3" as per the database.

Any ideas?

Thanks in advance
Ben

CORRECTION Database to DropDown NOT working

Hi Ben,

Which product is this ?

Best regards,
Max

Sorry Max...
CF5

Hi cyberrock,

Please leave the selected values box empty.

if the name of your drop-down is com['PaymentPreference'] then the value should be automatically set from the loaded data.

Bob

PS Please also remove the first = line from the options box - if you want to set an 'Empty Option' text please use the Empty Option box.