Field Mapping window - Associative Search Database lookups

This window is used to map the fields on the validation form with the fields populated from an associative search database lookup during extraction. 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. Any subsequent manual searches are not considered immediate searches.

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

Destination Field

Select from a list of all fields in the current class. The select field is populated with its corresponding Data Source Field during validation. If you want additional fields here, you must first add them to the class.

Data Source Field

Select a source field and map it to the corresponding Destination Field. The value of the Data Source Field populates the corresponding Destination Field when using the Database Lookup window and a search result is accepted.

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

Select this option so that 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.

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.

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