Solved

Prompt for duplicate record !

Posted on 2004-08-23
5
250 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 9

Accepted Solution

by:
prifre earned 125 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

726 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