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.

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.

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.

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

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