2 Replies Latest reply on Jan 11, 2011 10:28 AM by RGoyette

    removing duplicates

    RGoyette

      Title

      removing duplicates

      Post

      Here is a topic that comes up a lot.  Removing duplicates.  With a twist.

      I have one hundred proposals, each with a unique proposal number.  Each proposal has associated with it a list of team members.  The proposals and team members are separate tables.  Some proposals have duplicate team members, some do not.  For example:

      Proposal number 3600:

      Team members:

      bob

      john

      john

      fred

      bob

      john

      al

      I need a script that will step through all proposals, inspect the list of team members for each proposal and delete duplicates. 

      Suggestions?

      FM Pro v 11 on windows and mac os