What isQualifier lookup table?

[Former Member]

What is Qualifiers?What is Qualified table?Single -Value & Multi Valued look up fields? explain me with real time examples?

[Former Member · Accepted solution]

Hi Devaraj,

Qualified tables work on the combination of two types of fields where value of one or more fields (qualifiers) changes depending on the values of one or more other fields (non-qualifiers).

E.g. suppose we have a field “Price” whose values varies with the region for the same product. Here we have a fixed set of related legal values (combination of fields) that can be looked up into the main table. (For example Product A has a price of $30 in Southern region whereas $40 in Central region, then we get a set like Product A | Southern | $30, Product A | Central | $40 in the Lookup Qualified table)

To have deeper understanding refer this blog.

/people/pooja.khandelwal2/blog/2006/03/29/taming-the-animal--qualified-tables

Thanks and regards,

<b>Sagar Sonje,

Mark Helpful Answers</b>

[Former Member · Accepted solution]

Hi Sagar Sonje,

Thanks for your reply.It helps lot .

Best Regards

Devaraj PK