I have a database of around 2 - 3 hundred thousand listings and need to dedupe it against another database and just can't seem to get it going any subjestions on how to do this would be most helpful

MNC-Man

(Rob)

Relate the two files by the appropriate fields. Add a calculated field to the first which does a lookup to the second. Set it so that the field results in zero if there is no match, 1 otherwise. Delete all records with the value of 1 in that field.

Thanks for the reply journeyman I have implimented it in my files just one question in the calculation I'm useing the exact function and in the smaller database that I want deduped from the larger one it shows results great.. but when I implement it in the larger database it shows no results ?? how do I get it to show the results in the larger database ?? wich is the important one to see it in!

Reverse the table relationship.

Already Tried That..!

this is what the calculation Looks like could you please let me know if it looks right

Exact ( Telephone; MYOB US::Telephone) & Exact ( Telephone; USA east 3::Telephone)

Telephone = Large Database

MYOB US::Telephone = Small Database to be deduped from large database

Thanks alot

there are some topics about this in the FM Pro Help file... the topics are

"Finding duplicate values"

"Identifying duplicate values using a self-join relationship"

or maybe more...

hope that helps too~