Find duplicates

[Noreenmachine]

Hi there. I have a contacts database with names of our consultants and clients. If I just perform a "!" find, it doesn't find the duplicates. I don't know if I need to create a self-joining relationship just to find duplicates with the same FirstName and LastName. Is there an easier way to do this? The "Identifying duplicate values using a self-join relationship" section in the help menu is confusing to this newbie.

Thanks.

[BobWeaver]

I would create a calculated field to concatenate all the fields that determine what a duplicate is. In you case I assume it's first name and last name. So, make a new calculated field with the formula:

FirstName & LastName

Then you can do a search in this field using the ! character.

[Noreenmachine]

Hi there. Thanks for getting back to me. I have tried this and even though I have duplicates, this didn't work. I also followed the "Identifying duplicate values using a self-join relationship" in the FM Pro help menu and it also did not work.

Help! I'm desperate.

[BobWeaver]

Can you post some examples of duplicate records that this method would not find? Then we can find out what the problem is.

[Mats]

I also have the same problem. I imported a database oh about 1.000 clients and some of them occurs more then one.

I need a script witch can find i.e a duplicate of a customers number witch always are the same.

So as a short example:

if more then one record found with customer number 1234, display

I hope that explains what I am looking for :D