Obtaining A Match of Similar But Unique Fields

[tinacscs]

I am setting up an Input File that includes 90 unique tasks in each record. They have been set up to provide the name of the person that is assigned to that task (Pop Up menu from the Staff file). Everything works fine there.

Now I need to extract the names of all of the people that have been assigned tasks within that record and put them into a "Team" field. Obviously, I can't use 90 names and in every record there are multiple tasks assigned to one name. So I need a listing of all of the unique names to put into the Team field. I have tried Defining Values, Setting Up relationships, creating a script and I still cannot get a list of just the unique names to make up the team.

I need to complete this by Monday Morning 11/27! Can anyone help me?

[dspires]

If you just need the information in a report, use a sub-summary report - the wizard works great. Layout menu, new layout, columnar/list report, report with grouped data, select fields, organize by project(?).

[tinacscs]

Thank you so much for the info. I am going to do that right now. I really appreciate your input.