Re: Filemaker
Re: Filemaker
- Subject: Re: Filemaker
- From: Roger Howard <email@hidden>
- Date: Wed, 8 Dec 2004 15:08:11 -0800
On Dec 8, 2004, at 2:32 PM, Tim Mansour wrote:
Hi Wayne,
I'd probably just use a FileMaker relationship for this: concatenate
the company and contact names and use this key to find all duplicates.
Don't FMP relationships limit the size of the key to a fairly low
limit? I know some versions back it was useless to do it this way, due
to all the errant matches you'd get with long keys. It's easy to do in
AppleScript or FMP though - many methods, especially if you don't care
WHICH record you delete, you just want to delete all but one of the
dupes. I would just do it in AppleScript myself to avoid creating new
relationships, calc fields, or other cruft
Sort all the records by the fields you want to compare.
Repeat through each record
if the current record (or just some of its fields) is the same as the
previous record, delete the current record
end repeat
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden