Sue

Look for "unique" at http://www.briandunning.com/filemaker-custom-functions/results.php

Stephen

---

"Organizations which design systems are constrained to produce designs which are copies of the communication structures of these organizations." --- Melvin Conway

On Apr 19, 2011, at 11:03 AM, 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