This topic describes the steps to follow when you create a form that includes a select list populated with relevant database choices.
- Use the Lookup Table builder to create a database query (or inspect an XML variable) that returns the items (label and value fields) you want included in the select control.
- Optional: Use the Additional Data Definition inputs to add to the query results any label/value pairs you want to include in the select list.
Blank, for example.
- Use the object created by the Lookup Table builder as an input for a Select List builder or a Data Field Modifier builder.
Each of these builders will use the label/value choices returned by the Lookup Table builder.
Parent topic: Lookup Table builder