Please see Data Controls for the latest supported alternatives to this control
The Database Multi Select List automatically populates a single list of entries directly from a SQL table or similar source.
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.
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.
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:
