DB Lookup dialog box
A database lookup field allows users to specify items from a field a database table.
| Option | Description |
|---|---|
| Data Source | Select the desired ODBC data source. Only system data sources can be selected as a data source. If no ODBC Data Source was previously created, a new ODBC Data Source can be created by selecting the <New…> option. |
| Login ID | Specifies the user ID for connecting to the ODBC data source. This field is optional. If no entry is made, then the user account running the AutoStore service will be used. |
| Password | Specifies the password that corresponds to the User ID |
| Table | Choose Table to select the table from which values are loaded into the lookup list.. |
| Column | Select the name of the column from which values are loaded into the lookup
list. If the values and the labels need to be different, use the Query option. |
| Query | Choose this option to require the user to enter a SQL query. The SQL query will
produce the results to populate the list. If you select this option to create separate value and label columns without special conditions, use the following syntax: For more information on SQL scripting, see General SQL syntax. |
| Test | Check this button to validate the Data Source settings. |