How do you load data into a Combo Box from UD Table?

[tpogue (Trudy Pogue)]

Here are my notes on the three types of combo boxes. Is this what you’re looking for?

Combo Box

To create a simple dropdown list, use a Combo Box. For more info, see Kinetic Control Compendium - #8 by hmwillett.

Reusable (system list): set the following under Properties:

1. Data > EpBinding = View.Column e.g. SearchFilters.ColumnName
2. Reusable Combo > Type = ResourceGroup.ResourceGroupCombo (e.g.)
3. Reusable Combo > Sub Type = default
4. Advanced > Header = checked

Hardcoded list : set the following under Properties:

1. Data > EpBinding = View.Column e.g. SearchFilters.ProjectStatus
2. Advanced > Drop Down Style = DropDownList
3. Advanced > Append List = checked
4. Advanced > TextField = display
5. Advanced > Value Field = value
6. Add the list items under Advanced > List

BAQ list : set the following under Properties:

1. Data > EpBinding = View.Column e.g. SearchFilters.ProjectStatus
2. Advanced > Data Mode = rows
3. Advanced > BAQ Query = id of the BAQ with the results, e.g. IA_PartClassesnoX
4. Advanced > TextField = what shows up in the list, e.g. PartClass_Description
5. Advanced > Value Field = the key field, e.g. PartClass_ClassID

Hardcoded List example: