This window is used to map the fields on the validation form with the fields populated from a database lookup during extraction. This can use a relational database, a fuzzy database, or an associative search database for the search. Without this mapping, the lookup is unable to populate the necessary fields.

This window has the following options:

Enable Immediate Search

If enabled, this option enables you to configure the lookup button to perform a search based on validation field values, rather than manually-entered search criteria for the database lookup window. That means you can type a search criterion directly into the field on the validation form and then press the database lookup button to perform a search based on that value.

For relational databases, if there is a single matching record the validation form is automatically populated with the mapped fields. This is true for either "Search behavior" selected below.

For fuzzy database searches or associative searches, if there is a single record returned with 100% confidence, the validation form is populated automatically with this record. If however, the search returns multiple records, no record, or a single match with lower confidence, the search results window is displayed so that the Validation user can select a record or perform another search.

Search behavior

Important This option is available only when using a relational database.

Select one of the following values to determine how searches are preformed in Validation.

Per column

Select this value if you want Validation users to type a search string into an individual column of the search window. Only that column is searched for entries with a matching string.

All columns

Select this value if you want to search all visible columns simultaneously.

When selected, an additional text box is displayed at the top of the search window. This enables Validation users to type a string that is searched for in all columns of the database.

Important Queries that search all columns can take a long period of time, especially when wildcards are used. This may lead timeouts in large databases.

If timeouts do occur, reduce the number of visible columns or change the wildcard settings.

In addition to the above option, the following columns are displayed.

Destination Field

This is a field on the Validation form that is populated with its corresponding Data Source Field during production. This list is pre-populated based on the fields added to your form. If you want additional fields here, you must first add them to your customized form.

Data Source Field

This is a list of all locator fields or subfields in your project and can be a simple field or a table field. Select a source field and map it to the corresponding Desination Field. The value of the Data Source Field populates the corresponding Destination Field during production.

Note If you change the data source, any previous mapping are lost and you must perform this mapping again, using the new data source fields.

Immediate Search

This column is displayed for all database types. However, its behavior is different depending on the type of database selected.

For fuzzy databases and associative search databases, this column is active only when the "Enable Immediate Search" option is selected above.

For relational databases, this column is available only if the "Enable Immediate Search" option is selected and the "Search behavior" value is set to "Per column" above.

You can select one or more fields for this, and the corresponding field data is used as search text for the lookup for the specified columns. Any extracted text or manually entered text can be used as a search criteria.

When a Validation user presses on the Search button, if the "Immediate Search" fields have data on the document, a search is carried out immediately and results are either entered into the corresponding fields of the form or a search window displayed with possible records. This saves the Validation user from entering search criteria themselves, but does not restrict them from entering additional search criteria manually.

Immediate Search for all Columns

This option is available only for relational databases, and only if the "Enable Immediate Search" option is selected and the "Search behavior" value is set to "All columns" above.

You can select a single field only and the corresponding field data is used as search text for the lookup. Instead of restricting this to a specific column, all columns are searched. Any text extracted for this field or manually entered, can be used as search criteria.

When a Validation user presses the Search button, if the "Immediate Search for all Column" fields have data on the document, a search across all columns in the database is carried out immediately and results are either entered into the corresponding fields of the form or a search window displayed with possible records. This saves the Validation user from entering search criteria themselves, but does not restrict them from entering additional search criteria manually.

Definitions for the buttons at the bottom of this window can be found in Common Project Builder Buttons.