Skip to main content
Kofax

Return multiple matches and update the contents of a Table Field with these multiple records in Database Validation

9315

QAID # 9315 Published

Question / Problem:

Can Database Validation (also referred to as Database or DB Lookup) return multiple matches and update the contents of a Table Field with these multiple records?

Answer / Solution:

No, Database Validation is limited in the actions it can take when multiple matches are returned. The behavior is defined under the Options tab of the Database Validation Properties dialog box, and is limited to remaining on the Index Field for another entry (Remain on field), accepting the first record returned (Continue) or allowing the user to choose a record interactively (Allow user to choose match interactively).

If multiple records must be inserted into a Table Field, a Validation Script will be required to update the Table Field with the desired records. Validation Scripts include the KfxAcmDocument object for this purpose.

Applies to:

Product Version
CAPTURE 10.0
  10.1
  10.2
  11.0