Data Binding Drop-Down Controls Using Lookups

You can populate the options of a drop-down control, that is options binding, using a lookup through a data grid control set as data source on the same form.

You can use any type of lookup (Database, Repository List or Web API for data binding options of Check Box, List, Drop-Down, or Radio Button control.

1. Create a lookup.

2. Create a Grid Configuration using the lookup.

3. Create a form, and add a Data Grid control.

4. Modify properties of the Data Grid control as follows:

   1. In the Basic tab, set the Configuration Name property to the grid configuration created in Step 2.

   2. In the Advanced tab, set the Behavior property to Data Source.

5. Add a Drop-Down control to the form.

6. Modify properties of the Drop-Down control as follows:

   1. In the Advanced tab, set the Text Parameter and Value Parameter properties to the column names of the grid as required.

   2. In the Scripts tab, set the script for the Options property as follows:

      return control.findById("G1").source;