Detach Lookup Table

On the File | File Editor tab, in the View group: Select Detach Lookup Table to detach a lookup table from the current field.

This option is also available on the Lookup Table Editor tab for Lookup Tables.

One of the features of Lookup tables is that they can be locked to a file. When a Lookup table is locked to a file, it cannot be detached.

If a file with Lookup tables is opened and a linked Lookup file is missing, you are given the option to browse for the missing Lookup file or drop the Lookup table for that column. If more than one Lookup file is missing, you also have the option of dropping ALL missing Lookup tables.