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:

select <ValueField>, <DisplayField>
   from <Table>

For more information on SQL scripting, see General SQL syntax.

Test Check this button to validate the Data Source settings.