Qualified Lookup Tables

[Former Member]

Hello,

Why are Qualified Lookup Tables needed? Please some explain a example please? Do they make attributes as qualifiers in qualified lookup tables? or some thing else?

What exctactly two or more/one/none fields meant for?

Note: Please don't copy the library links( I ready read it and could not understand extactly they are)

Thanks,

POWERED

[Former Member · Accepted solution]

Hi,

Qualified lookup tables are used to store the values of Two types of fields Qualifiers and non Qualifiers.

Qualifiers are the fields whoes values changes based on the values of other fields called Non Qualifiers.And are associated with the main Table Records.

Non Qualifiers are only part of Qualified lookup Tables.

In Data Manager QualifiedLookUp Tables appear in the lower right Part.

For example in your main table supoose you have an Employee Repository that maintains employee information (Name,Telephone,Address etc).One employee can have sitting arrangement on different office locations.

Then if Location is your main table field in that case for 10 places you have to make 10 seperate entries of One Employee name with different locations,that will unnecessarily increase the records of your main table and also duplicate for Employee name field as well.

To resolve this make a look up field location in main table for qualified lookUp Table Locations.

In Locations table create a Non Qualifier field OfficeADD(lookup flat )for Officelocation table .

And create two more fields DeskNo. and Telephone No.(both as qualifiers)for every location the desk no. and telephone no. will be different.

In Officelocation table has one field Name which contains address of diffrent locations.

Now according to the Qualifier and Non Qualifier concept

In main table for an Employee say Ravindra you can go qualifiedLookUp table and select a value for OfficeADD(a non qualifier) and set valus for Desk no. and telephone no.(Qualifiers) as well.

Reward if Helpful.

Vinay Yadav

Edited by: Vinay Yadav on May 21, 2008 1:07 PM

[Former Member]

Hi,

Please follow the link below in addition to the above post.

/people/community.user/blog/2006/12/20/so-is-that-the-qualifier-or-the-non-qualifier

Thanks,

Felix

[Former Member]

Hello,

Qualified lookup Table has two type of fields :

Qualifiers( Whose value can vary for each main table record)

Non Qualifiers ( Fixed set of records)

If ur field Field3 Qualifier or Nonqualifier???

While importing values for Qualified table u always import Non Qualifiers first.

And Non qualifiers are imported every time u import main table record.

Go through this........... u will understand concept of Qualified Table

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

Thanks,

Maheshwari

[Former Member]

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

Check this blog for basics..