Databases and the Database Locator
The main database selected for this locator enables you to configure the physical relationship between fields on the Fields tab and subsets of the database fields on the Search Masks tab. The exclusion database cannot be configured in this way, so as a result, the fields need to be located close together in order to be recognized.
All databases are added to the project via the Project Settings.
For example, a form may contain two addresses. The first address is for the supplier and the second for the organization receiving the invoice. The organization has two databases:
-
A database containing records for all suppliers, including the organization. (Suppliers)
-
A database containing records for all organization sites. (CorporateDetails)
A Database Locator is needed to extract supplier names and addresses so the Suppliers database is selected for the locator. This means that any matching records are returned as alternatives.
The CorporateDetails database is selected because it contains records that should not be found by this locator.
A document contains both a supplier address that is contained in the Suppliers database, and one of the corporate addresses that is contained in the CorporateDetails database. Because of the above configuration, the second database eliminates the corporate address, and only the supplier record is returned.