Defining index field validation by using a database

You can validate a captured index value by using a column in an external database. You can also populate an index field by using a value that is retrieved from a database.

To define index field validation or population by using a database:

1. Start FastDoc in Datacap Server mode.
2. On the Datacap window, click the Configure documents, pages, and fields icon.
3. In the Batch Structure pane, select the field that you want to validate by using a database.
4. Click the Ruleset tab and select the Validate Fields ruleset.
5. Select the check box for the Lookup section.
6. In the Database field, enter a connection string that can connect FastDoc to your external database.
   Based on the type of database and the driver that you are using, you might also need to set up a System DSN.
7. Enter an SQL statement that determines whether only validation is done, or whether a value from a different database column is returned.
8. Enter a comma and True after the SQL statement to populate the index field with the result.
9. Click the Populate Field check box.
10. Click Save.