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 34.5. Lookup Table Wizard


Table 34.1. 

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