Qualified Lookup Cells 

Taxonomy lookup fields are always single-valued, so each main table record always has just one set of attribute values based on the single category assigned to it, and these values can be neatly displayed vertically as subfields of the category in the Record Detail tab.

By contrast, qualified lookup fields are multi-valued, so each product can have multiple sets of qualifier values, each associated with one of the qualified table records assigned to it. Consequently, a qualified lookup field requires a specialized cell in the Record Detail tab to display the qualified lookup values, as shown in the figure below.

Unlike other types of lookup tables, which typically use just a single display field for the lookup field value, each qualified table record will usually have multiple display fields, which can include any of the fields of the qualified table itself, as well as any of the qualifiers.

Each qualified lookup value is the concatenation of the values of the multiple display fields and qualifiers, separated by semicolons (;).This concatenated value is displayed as the value of the qualified table record in the qualified lookup cell and also in the qualified lookup search tab.

Directly underneath the name of the qualified lookup field, MDM displays [m of n] (where ‘n’ is the total number of qualified table records linked to the current main table record and ‘m’ is number of those n records that match the current search selections for the qualified lookup field). The two numbers will be the same if: (1) the Filter checkbox is not currently checked; or (2) there are no search selections currently in effect for the qualified lookup field.