• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Filemaker
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Filemaker

  • Subject: Re: Filemaker
  • From: waynemelrose <email@hidden>
  • Date: Wed, 8 Dec 2004 20:57:33 +0100
Thanks for the reply everyone..

this is the best explaination Andi..

I have option 2

Pepsi - John Smith
Pepsi - John Smith

and Erik, to answer your question, at this point, this database is such a mess, im not too worried about which of the duplicates I delete, if it is the wrong one, I will have the sales staff update it manually... oops! I'm a bad man!

Either way Im going to put it back on track..

Andi, what do you think?

Wayne..


On Dec 8, 2004, at 8:49 PM, Andi Elsasser wrote:

Hi Wayne,

I agree that this would best be done within FileMaker.

But before explaining how, can you clarify one thing? Do you have duplicate
companies AND duplicate contacts? Or only duplicate contacts?

So, do you have:

Pepsi - John Smith, John Smith

-or-

Pepsi - John Smith
Pepsi - John Smith

-or-

Pepsi - John Smith
Pepsi - Mary Johnson
Coke - John Smith
Coke - Mary Johnson

Your approach will be different depending upon your answer.

:)

Andrea


From: waynemelrose <email@hidden>
Date: 2004/12/08 Wed PM 01:57:55 EST
To: AppleScript <email@hidden>
Subject: Filemaker

Hi there..

It might be a little late in the evening for me.. I'm Hoping someone
out there is a little more fresh ;)

I have a simple filemaker database, I have many records of business
with their respective contacts (say 5 per company)

My problem is that i have mulitple records (that are useless) for the
same contact person.

So i want to write a script that will search for company name, then
contact, and find the records that are the same for those requirements,
then delete all but 1..

any thoughts?

wayne melrose

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden 

This email sent to email@hidden


Andrea Elsasser
Developer
Metamorpho Systems
voice/fax: 212.996.1211
http://www.metamorphosystems.com
email: email@hidden


_______________________________________________
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




    

  • Prev by Date:
Re: swf movie

    • 

  • Next by Date:
Re: Re: Filemaker

    • 

  • Previous by thread:
Re: Filemaker

    • 

  • Next by thread:
Re: Re: Filemaker

    • 

  • Index(es):

      

    • Date
      • 

    • Thread
      • 

    

    •