Re: list of portal values in order, w/o duplicates?

[Sue]

Thank you!!!  This works perfectly.  Big headache solved.

Sue

On Apr 19, 2011, at 11:26 AM, Tom Elliott wrote:

Sue

Well, the easy way is to let FMP do the work for you - via a valuelist.

Define a valuelist, "myList", to use values from related::x, include only related values starting from <parent>

Then define your field as Substitute ( ValueListItems ( Get ( FileName ) ; "myList" ) ; ¶ ; "," )

cheers

Tom

On 19 Apr 2011, at 18:03, Sue wrote:

I have about 200,000 records sorted into 12,000 groups.

Each record has a value for x.

I need a comma separated list of all the x values in Group a (b,c,d...etc)

I tried this:

List (Related Record value x)
which in one instance gives me this:

8
8+
9
9+
10
10+
11
11+
12
9+
10
10+
11
11+
12
13


then I calculate:

Substitute (List, paragraph symbol,",")

which gives me a result like this:

8,8+,9,9+,10,10+,11,11+,12,9+,10,10+,11,11+,12,13

which is close to what I want.

BUT, what I really want is this x value list (in numerical order (or alphabetical as the case may be)) without any duplicate values--

so the above should be:

8,8+,9,9+,10,10+,11,11+,12,13

Other groups return lists that are far further from numerical or alphabetical order. I think there must be a way to do this as Filemaker creates value lists based on relationships that don't show duplicate values and are sorted--but how do I create a field that mimics that?

Any suggestions?

Directions to a web page that describes how to do this would be great if such a place exists.

Thanks very much!

Sue