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
|