Database Lookup field

A database lookup field allows users to specify items from a field a database table.

Option Description
Data source Select the desired data source. Note that only a system data source can be selected as a data source. If no data source was previously created, a new data source can be created by click the browse button (). If you create a new data source, the Keep alive command will continually ping the Data Source.
Login ID Enter the Login ID for the Data Source. Entering a value for this field is optional. If no entry is made, then the user account running the AutoStore service will be used.
Password Enter the Password for the Login ID. If no entry is made for Login ID, then the user account running the AutoStore service will be used. Therefore, no password will need to be entered.
Table If Table is selected, then the name of the table can be selected from the drop down menu.
Value column For Value Column, the user must select the name of the column from which values will be loaded into the lookup list.
Display column For Display Column, the user may select the name of the column which will provide the names which will be displayed in the lookup list. Note that the Value Column is mandatory while Display Column is optional. If nothing is entered for Display Column, those values listed from the Value Column will be displayed.
Query If Query is selected, then the user must enter a SQL query. The SQL query will produce the results which will populate the database lookup list. For more information on SQL scripting syntax see General SQL syntax.
Test Click this button to test connection to a specified table on the data source.
Allow multiple selection If Allow multiple selection is selected, the user can make multiple selections based on the results populated within the database lookup list.
Visible Clear this check box to hide the field so that it does not display on the device panel.
Enabled Clear this check box to display the field in read-only mode on the device panel.