AnsweredAssumed Answered

Duplicate Records Not Needed

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

Title

Duplicate Records Not Needed

Post

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.

Outcomes