Lookups

A lookup retrieves specified data from a data source. The lookup is an SQL query against an internal table in the IMan database or any external ODBC or OleDB compliant database.

You can parametrise the query and use it to confirm that a record exists, find key data in an external database or merge small datasets.

There are two stages to Lookups Setup.