Types of Lookup Tables

After opening the New lookup table wizard, you need to select the desired lookup table type. After selecting the radio button and clicking Next, the corresponding wizard opens.

Lookup Table Wizard

Figure 35.5. Lookup Table Wizard


Table 35.1. Types of Lookup Tables

Lookup TableWhole Table in MemoryAllows Duplicated Key Values
Simple Lookup TableYesYes
Database Lookup TableNoYes
Range Lookup TableYesNo, but intervals may overlap
Persistent Lookup TableNoYes
Aspell Lookup TableYesYes