Legacy Control - Database Multi Select List

Please see Data Controls for the latest supported alternatives to this control
Legacy Control - Database Multi Select List
The Database Multi Select List automatically populates a single list of entries directly from a SQL table or similar source.
1

Field Information

1. Field Information
Displays the current field name and pages on which it is used.  The Field Information button gives further information including links to the pages that the field is used on and details of any reports in which it is used. 
2

Field Name

2. Field Name
Give your field an appropriate name.  This is particularly important if using it in a calculation or report.  Changing a field name will not automatically update corresponding reports that use that field.
3

Field Help

3. Field Help
Enter the text you wish the agent to see when hovering over the control.
4

Field Text

4. Field Text
Enter the text for the control as you wish it appear to the agent.
5

Advanced Properties

5. Advanced Properties
Launches a Wizard to take users step-by-step in selecting a datasource, writing a query and selecting the column of data to display.
6

Field Validation

6. Field Validation
Use to apply field validation to the control (in conjunction with a button marked to Check Page
7

Save button

7. Save button
Save changes.
 
Using the Advanced Properties button:
 
1) Select a datasource type.  the next options that appear will depend on the datasource selected.  In this example Microsoft SQL is used to ensure the list is continually updated.
 
 2) For SQL: select a SQL server or enter server name:
   
 
3) Select a database from the list presented:
 
4) Write the SQL query required to retrieve the data:
 
5) As the query is not searching for one particular piece of data this screen can be ignored, and the Next button clicked to move on:
 
6) Select the column from the table to display in the list displayed.  Option Value is the value returned to the database (for reporting or coding purposes) and the Option Text is displayed to the agent.  Usually these would both be the same, although not necessarily.
 
7) Click on the Finish button.
 
When the script is run the data will display as follows: