New Lookup Table

To create a lookup table, select File | New | New Lookup Table or File | Lookup Table | Create.

File

Enter the Name of a new file, choose a File Type, and enter its Title. If you choose the type LOOKUP the Define Lookup Table Nesting Levels prompt will be enabled (see below).

Nesting levels

To create a hierarchy of Lookup Tables, enter the number of nesting levels. By default, a single level lookup table is created and the default is 1). option and then enter a number which defines the number of levels.

When nesting levels are defined, the field names are hard-coded to Code n and Desc n (where n is the nesting level). The width of the fields are defined in Options | Lookup Tables.

Attach a lookup table

To create and attach a lookup table:

  1. Define the contents of a lookup table
  2. Compile a lookup table
  3. Attach a lookup table
  4. Validate a lookup table

Do not delete the lookup table source files (*.LDT). You will often need to edit or extend them. Also, you can only use a lookup table compiled with the same version of software. This is important when you are creating a set of lookup tables and then distributing them to other computers on site. 

For more information, refer to the Lookup Table Options topic.

Concept Link IconSee Also