Duplicate records?

[Bridget Eley]

Hi Shai

Use field validation to ensure that entries are unique, with a custom
message to tell the user what to do if they aren't.

Bridget Eley



in article newscache$zgcnih$rb$1@lnews.actcom.co.il, shai Ben Mordechai
(Rosenblum) at [email]gla@actcom.co.il[/email] wrote on 27/7/03 6:22 AM:

> Hi all,
> Using Windows XP, FMP 6.
> What is the best method for entry new record, search for duplications and
> have a message regarding what to do next ?(delete, add)
> TIA
>
> Shai

[shai Ben Mordechai \(Rosenblum\)]

Bridget,
yeap... I know that I can define the last and first name as concatenation
and make it unique. But... Sometime people have the same last name and first
name...

TIA

Shai

[Bebop & Rocksteady]

> Using Windows XP, FMP 6.
> What is the best method for entry new record, search for duplications and
> have a message regarding what to do next ?(delete, add)

I would give each record a Client ID Number and use the auto create and
validate function.

If some one else enters a record with the same details.. I would have a
list view and with sort by name, rank and serial number as well as a Go,
Omit and delete button... This way it is very quick and easy to see if two
records are the same, and to delete one if it is...

To see if the deatils of a record is a duplicate of another you would have
to search all fields... no spelling mistakes... and if record has more data
than the other it will not be found.

You could make a script that copies the details of a found record in browse
mode, switches to find mode then paste the data and perfom find.... (you
shouldn't need any error capturing as it will always find the one record...

but if there are duplicates of the data entered it will be found. But again
if one record has more data than the other or has a spelling mistake or
data is entered wrong, etc... it won't be found.

As I said the easiest and most logical way for find duplicates is making a
list mode report with your buttons... (But thats just me... and works well
for me)

--
----------------------------------------
Quantum Illusions: [url]http://quantum.2ya.com[/url]
Pegasus Mail Support Site: [url]http://pegasus.quantum.2ya.com[/url]
Freeware Site: [url]http://freeware.quantum.2ya.com[/url]
DATA Solutions: [url]http://datasolutions.quantum.2ya.com[/url]

If you truly want to contact me click the link
[url]http://quantum.2ya.com/email.htm[/url]