Single-Valued Lookup Cells 

Recall that MDM often enforces data integrity by creating a predefined set of lookup values, either as the records of a lookup subtable (where the value of a lookup field is restricted to the set of values of the subtable records), or as the set of values defined for a text attribute. These lookup values are displayed in drop-down controls that contain the set of values that can be selected by the user:

Drop-down list

For a single-valued lookup field into a flat table or a text attribute, the cell in the Record Detail tab is a drop-down control that contains a list (figure below).

Drop-down tree

For a single-valued lookup field into a hierarchy table, the cell in the Record Detail tab is a drop-down control that contains a tree structure (figure below).

You do not need to click on the down triangle in a drop-down list or tree control to open it. You can simply start typing once the drop-down control has the focus, and it will open automatically.

The type-ahead seek feature jumps to the next matching item in a list or tree. It even opens tree nodes that are closed; that is, MDM will expand branches to find nodes that are not visible.