A Lookup List field allows users to specify items from a field a database table.
|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:
|Query||Choose this option to enter a SQL query to produce results that populate the list.
<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.|