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
>>