Working with Qualified Tables 

A qualified table is a special kind of lookup table that is extremely versatile. It can be used to efficiently store complex relationships between a main table record and one or more lookup table records that contain various types of additional information.

A qualified table stores a set of lookup records, and also supports qualifiers, database “subfields” that apply not to the qualified table record by itself, but rather to each association of a qualified table record with a main table record.

Qualified tables offer self-configuring, out-of-the-box support for:

·        Multiple prices (including quantity price breaks)

·        Cross-reference part numbers

·        Other distributor-, supplier-, and customer-specific information

·        Product applications for application-based search

Each of the different uses of a qualified table is described in the following sections.