Map a Dropdown to a data source

Dropdown controls can be mapped to data source tables, so that the contents of the list comes from that table. To do this, set the Dropdown object’s Options property to Datasource List. In the dialog box, select the data source, table and column(s). The same dialog gives you control over how the list is constructed. Key points:

• You can choose to show the Text and Value from different columns. For example, if you have Code and Description columns. Together this will make more sense to the user than Code alone. If you just want the item itself, set Text and Value to the same thing.
• Where the field equals allows you to filter the list by some condition.
• Order by allows you to order by another column.
• Default text or value sets the initial value held in the dropdown list. If not set, the initial value will be null. If set and the user does not make a selection, this is the value that will be assigned.
• Placeholder lets you add a message to the user that will be replaced when a value is selected. For example, Enter code might be your placeholder text. Placeholder does not override any Default text or value setting on assignment.