Working with Lookup Tables 

As you may recall, MDM tables can have special fields which get their values by looking into other tables. These fields, called lookup fields, provide preset values for record editors to choose from. The table which provides these values is called the lookup table. When you edit a lookup field, the display field(s) of each record in the lookup table appears as a separate value in the field’s drop-down list.

Lookup tables may be flat, hierarchy, taxonomy, or qualified table types. The following sections describe these tables in more detail.

When you add, delete, or modify records in a lookup table, the results of these changes are reflected in the values of the lookup fields which look into the modified table.

Object lookup tables are described in Object Tables at a Glance.