[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Prompt for duplicate record !

Posted on 2004-08-23
5
Medium Priority
?
274 Views
Last Modified: 2010-04-27
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.
0
Comment
Question by:gurshaan
  • 2
2 Comments
 
LVL 9

Accepted Solution

by:
prifre earned 500 total points
ID: 11878381
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
 
LVL 9

Expert Comment

by:prifre
ID: 12207183
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month20 days, 14 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question