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 >
