Prompt for duplicate record !

What script I should to find out about duplicate RECORD in one particular field ?

Let say customer  JAY MUSIC COMPANY already exist .
Today my try to add same customer one more time by mistake
Question:  What script or function should I use to prompt for duplicate or prevent my employee to adding duplicate customer.
gurshaanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
prifreConnect With a Mentor Commented:
Hi,

There are several solutions:
1) In the Field Definition, check "Unique value" under "Options..." (you can even have a custom message when someone tries to enter a duplicate)
2) You can search for already present duplicate records in a field, by writing "!" in the field.
3) You can create a script that removes or marks duplicate records based on exactly what you consider duplicate (for example, if the first 5 characters are the same, or if 2 fields are the same in 2 records.) After marking, you can go through them manually and remove.

I usually use a combination of all 3 above when I work with FM. I define the database as good as possible - so people never enter exact duplicates. I run from time to time a check on for example adresses (that is ok if they are duplicates) to see if records are duplicates, but for example the names are misspellt. And if I have imported many records, I use a script to find imported duplicates and remove them automatically.

hope that helps!

with a smile
/prifre

(I use a Swedish FileMaker, so I cannot give exact menu/button names. Sorry.)
0
 
prifreCommented:
Whatever. No replies from the one who asks a question is sooo irritating. I believe my suggestions would have solved the problem, but now, no one can tell.
with a sad smile
/prifre
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.