Solved

Prompt for duplicate record !

Posted on 2004-08-23
5
229 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
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now