Lookup List field
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:
|
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 load | The user can select the maximum number of rows to load into the display when the lookup list is first displayed. The default value is 25, and the greatest number of rows that can be specified for this option is 200. |