Database Lookup tab

The Database Lookup tab on the Job Setup window is used to populate or validate, batch and document index fields for ODBC-compliant data sources. A configuration wizard is used to specify the data source, define how the lookup is performed and what data is used to populate index fields or validate the contents of index fields. A job setup may contain more than one Lookup. Each Lookup may be to a different data source and may be used to populate or validate selected index fields. Lookups may occur during scanning when the index value used for the lookup is a result of a barcode read or an OCR action.

Each Lookup takes the form: SELECT <table column 1>, <table column 2>, … <table column n> FROM <data source> WHERE <table column x> = <index field value> or select: WHERE <table column x> = <index field value> AND <table column y> = <index field value>.