AnsweredAssumed Answered

Duplicate Records Not Needed

Question asked by BernieGrice on Nov 1, 2010
Latest reply on Nov 1, 2010 by philmodjunk


Duplicate Records Not Needed


New to the FM program and would like to mark/flag/delete all duplicate records.  

Brief rundown:  A large database of names and addresses with many duplicates, and I only need one entry per.  I've created a new field "BuyerCode" and placed FName, MIntial, LName and address (street only), using a calculation under Manage Database.  Then I used the "!" operator to find unique in the "BuyerCode" field, but some records/names are not represented in the resulting find.

Thank you in advance.