Types of Lookup Tables

After opening the New lookup table wizard, you need to select the desired lookup table type.

Table 34.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