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:
I need a script that will step through all proposals, inspect the list of team members for each proposal and delete duplicates.
FM Pro v 11 on windows and mac os