AnsweredAssumed Answered

removing duplicates

Question asked by RGoyette on Jan 11, 2011
Latest reply on Jan 11, 2011 by 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

Outcomes