two column drop down

[willklumb]

Can you create a 2 column drop down showing the value you wait to insert and the description attached to the value in the lookup table

[bnorris391]

Greetings -

I couldn't find a way to connect 2 fields in the drop down box. However, a possibility could be to create a custom value drop down box. The display would be the item and its description. The Item would then be the field.This might work for you if the number of possible items to select is manageable.

Attached is a screen shot of how the Caspio edit looks.

Best of luck

B. Norris

http://www.intellestate.com

[ShWolf]

Hi,

You can use a cascading drop-down list for this.

Example:

In your table you have fields “Value†and “Descriptionâ€.

Create a DataPage based on this table (or on another one if needed).

For the “Value†field, select “DropDownâ€, for the “Description†field select “Cascading DropDownâ€.

For the “Cascading†field, select “Value†in the “Parent field†and “Filter byâ€.

So, in the web form, when you select value in the first drop-down list, cascading DropDown will show you description of this value.

Also, you can select the “Continue next element on the same line†option for the first drop-down list (second drop-down list will be on the same line in the DataPage).

If you don’t want to submit Description to the table (when your DataPage is based on another table that doesn’t have a “Description†field), you can use Virtual Field with the same cascading DropDown settings.

Hope this helps.