Lookup Tables

Lookup tables improve the speed of query execution by performing an often-used pattern of query processing with a single access to the database.

The main Lookup Tables dialog box displays the following information for any previously-defined lookup tables.

Field	Description
Name	Name of the lookup table. The name is referenced in the Lookup command.
Key	Name of the column (field) used as the "key" for looking up information.
Return	Name of the column or expression returned for each corresponding key.

From the main Lookup Tables dialog box, you can click Add to add a new lookup table, click Edit to edit information on an existing lookup table, or click Delete to delete a lookup table. To use your lookup table, create a Lookup Variable.