Skip to Content
0
Former Member
Dec 19, 2006 at 04:20 AM

When to use qualified lookup table?

22 Views

Hi all,

I am confused with the qualified lookup table and lookup table, for the situation that a company has more than one contact person, I created a table "contact person", which has following fields: first name, last name, phone number, email address.

Questions:

1. should I set "contact person" as a lookup table or qualified lookup table?

2. if to be set as qualified lookup table, which field should be qualifier field? what is the difference between qualifier field and non-qualifier field?

your reply will be very appreciable

Bin