FMPRO-L Archives

April 2011, Week 3

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Tue, 19 Apr 2011 11:03:32 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (59 lines)
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

ATOM RSS1 RSS2