Lookup List field options

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

Option Description
ODBC Data Source Select an ODBC data source to connect with a data provider. You can click "<New...>" to configure a new ODBC data source item. Only system data sources can be selected as a data source.
ODBC Data Sources Administrator Click this button to open the Windows ODBC Data Source Administrator application to add, delete, or configure data sources with user data source names (DSNs).
User ID Enter a user ID that has permissions to the database. This field is optional. If it is left empty the user account running the AutoStore service will be used.
Password Enter the password that corresponds to the User ID.
Connect Click this button to connect to the ODBC Data Source.
Table View Choose this option to select the table or view. Then specify the following:
  • Value Column — Select the name of the column from which values will be loaded into the lookup list. This value is required.
  • Display Column — Select the name of the column which will provide the names which will be displayed in the lookup list. This value is optional. If this value is left blank, values listed in the Value Column will be displayed in the device console.
  • Description Column — Select the name of the column which will provide the description for the names displayed in the lookup list. This value is optional. Values from this column will be displayed in the details section of the user interface. This option is only available for device panels that display in color.
Query Choose this option to enter a SQL query to produce results that populate the list. Entries for <ValueField> and <DisplayField> are required in the SQL query.

For information about SQL scripting syntax see General SQL Syntax.

Maximum number of rows to pre-load The user can select the maximum number of rows to preload into the display when the lookup list is first displayed. The default value is 50, and the greatest number of rows that can be specified for this option is 100. If more than 100 rows must be searched, the user can use the search option located on the device panel. Note that when Query is chosen, then only preloaded rows will be searched.
Allow Multiple Selection Select this check box to allow users to make multiple selections based on the results populated within the lookup list.
Allow user to add items Select this check box to allow users to insert their own values into the lookup list.
Maximum number of search results to display Specify the number of results returned when a search is executed. The default value is 25 and the maximum value is 200.