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.