Comparing 2 lists - how to setup

[jhahes]

I would really appreciate if someone could help me with the following.

I have one list (3 million records)

Table = DNC
Field 1 - Area code
Field 2 - Phone number



I have another list that has say 1000 records

Table = Phone list
field 1 - area code
field 2 - phone number


What type of relationship do I need to setup in order for me to see which records in the Phone list table are not in the DNC table?


thanks for any help

Josh

 

[boblarson]

In the queries check out the Unmatched query wizard.