Database Validation Properties Window - Table Settings Tab

Use this drop-down list to select the index field in your document class to use for the database validation.

Use this drop-down list box to select the table to use for the database validation. Select from a list of all the tables in the database or data source specified on the Database tab.

For SharePoint database types, select the SharePoint list to use for the validation. The available items vary, depending on the selected subsite.

Use this drop-down list box to select the column in the database to search for a match to the index field specified in "Index field to validate." Select from a list of all the columns in the table.

The match is submitted to the database or data source as an SQL "equals" query. The exact behavior of the match (for example, is it case-sensitive or not?) depends on the specified database or data source.

Use this check box to select the auto-fill capability of the Database Validation feature. When selected, the frame below the check box is populated with fields. Auto-fill uses the results from the database lookup to fill in specified index fields when validating a batch.

This list displays when "Auto-fill index fields from results" is selected. The list contains every column in the specified table.

This list displays when "Auto-fill index fields from results" is checked. The list contains a drop-down list box for each index field in your document class. For each row in the list, you can select an index field to match up with a database column. For example, if the Database Results Column is "Address" and you set the matching Tungsten Capture index field to be "Street Address," then the contents of "Address" are copied into "Street Address" by the auto-fill function when it runs during the validation process.

Auto-fill is unavailable for all index fields by default. If you leave a row blank, then auto-fill is not enabled for that index field. You can turn off auto-fill by selecting "none" from the drop-down list.

If you select "none", the field either remains blank or becomes blank if an index field had been assigned to it.

You can also select "display only" instead of an index field. In this case, the value for the database column appears in the Multiple Matches Found window, but is not used for auto-fill. You may elect to display these additional values to help resolve conflicts if there is more than one possible match during lookup.