Types of Lookup Tables

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

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