Remove duplicates from a List() function

[FredP]

I am using the list function to list the users that are part of a particular project.

 

List (Shot_Tasks | Project::TaskEmployeeID)

 

This returns what it should. If UserId#1 has 3 tasks in that project, and UserID#2 has 4 tasks in that project, the field might look something like this:

 

UserId#1

UserId#2

UserId#2

UserId#1

UserId#2

UserId#2

UserId#1

 

I would like to strip that down and remove duplicates from the field. Possible?

 

Fred

[aaa]

Hi, Fred.

ValueListItems() function must help here.

Creat conditional Value List then use this function.

Other way is to right custom recursive function. I does not tried it, but i think it is possible.

If first way will not help you, let know. I will try second way.

[aaa]

And this is second way.

It works in findset too.

[Crazycatz01]

Hi,

 

I just came across this thread via google, and am looking for an answer as well. Did you figure out how to do this?

 

I would like to avoid use of custom functions since my database is being designed to be run on filemaker go.

 

Thanks!

[doughemi]

As aaa said, ValueListItems() is the way to go.

 

Create a value list using values from your field (a value list always contains only unique values), and then a calc field using ValueListItems(Get(FileName);YourValueList).