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.