Choice List Database Setup Window

Use the Choice List Setup window to specify which ODBC data source is used to set up a predefined list of index field values that are retrieved from an existing database. After connecting to the database, set the database table/column and fields containing the values you want to appear on the choice list.

Data Source Specification

ODBC data source: Sets the ODBC data source used to link your index field to a database. The data source list is based on the user or system ODBC data source names configured from your ODBC Data Source Administrator.
Refresh: Updates the list of ODBC data sources (if the list changes after you open the Database Lookup Setup window).
User name: Sets the user name for the login required to access the data source, if applicable.
Password: Sets the password for the login required to access the data source, if applicable.
Workgroup file name: Sets the name of the Workgroup information file associated with the Microsoft Access database, if you select an Access data source that is password-protected. Click Browse to navigate to the file name.
Connect: Connects to the database associated with the data source you specified. After you click Connect, the Choice List Information settings are available.

Choice List Information

Table: Sets the name of the table containing the field whose values are used to build the choice list on the Indexing panel. The list of tables is based on the selected data source.
Choice field: Sets the field whose values appear on the choice list on the Indexing panel. The list of choice fields is based on the table selection.
Description field: (Optional) Sets a secondary field (from the same database) whose values appear in the Description column on the choice list on the Indexing panel.