Scripting omitting duplicate records in found set?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Waldo Pepper - 31 Jul 2008 02:04 GMT

Dumb question of the week. Filemaker 6 (client won't pony up for upgrade

:-). I've created a file that does the counter thing with a self-join

that flags records as "Unique" or "Duplicate". It's based wholly on a
single email address field. That part works fine when I'm in Show All
Records set; however when I'm in a smaller set of found records within
the same file it doesn't work as all of the records in the file are
being compared whether they're in the found set or not (at least that's
what I think is happening). My need is simple: if I'm in a found set of
email addresses and there are duplicates, I want to script the omitting
of any dupes so we can export that particular group of email addresses
while not deleting anything in the found set or any other existing
records in the file. If I can't get the counter thing to work, can
anyone suggest or show me a simple looping script to do what I'm
describing? Many thanks for any suggestions. I'm sure this won't be
rocket science for 99% of you!

pd

Reply to this Message

Martin Trautmann - 31 Jul 2008 07:08 GMT

> Dumb question of the week. Filemaker 6 (client won't pony up for upgrade
> :-). I've created a file that does the counter thing with a self-join
[quoted text clipped - 11 lines]
> describing? Many thanks for any suggestions. I'm sure this won't be
> rocket science for 99% of you!

Use a serial number "serial" for all records (auto enter).

Use a relation "email" from email to email.

Use a calculation field with the result
email::serial = serial

The first unique email will see its own serial number. Thus the result
of the calculation will be 1.

Any other record will see the first matching serial number, which
differs from the own one. Thus the result will be 0.

Do a find on "1" or do omit everything with a zero here to exclude
duplicates. Or search for zero and delete the duplicates.

HTH,
Martin

Reply to this Message