List Unique Occurances

[emjay]

This may be an easy one but I'm stumped.

I have a db with the fields firstname, lastname and other data. I'm importing records from an excel spreadsheet. I get multiple firstname/lastname combinations. I'd like to get a unique list of all the the firstname/lastnames without the multiple repeats. I can't figure out how to do this.

Much obliged for any help.

Cheers,

MJ

[bcooney]

Hate to discourage you, but finding duplicates after import is not easy. The crux of the matter is "What is a Duplicate?" If you can come up with a DupCheck calc field, then in Find mode you can search for records that have the same data in DupCheck by using the "!" symbol (the DupCheck field must be set to be Unique). Check out John Mark Osborne's tip: Isolating Duplicates

I think you'll end up with a found set of possible duplicates that you'll let the user view and delete the records that they've decided are the real duplicates. Then, you'll have to help them with the appropriate warnings when they delete (for example, what if they are deleting a record that has children?).