I've got a situation where table A is related to table B. I'm in table
A, and there are multiple records in table B. I would like to grab the
contents from field x in table B and aggregate them into a list in
table A, with a carriage return between each value. Is there a
convenient way to do this?

Thanks,
Kevin

look into the List function, the helpfile may help you out.

keep well, ursus

"Kevin Audleman" <kevin.audleman (AT) gmail (DOT) com> schreef in bericht
news:1173134115.421805.140580 (AT) j27g2000cwj (DOT) googlegroups.com...

On Mar 5, 3:35 pm, "Kevin Audleman" <kevin.audle... (AT) gmail (DOT) com> wrote:
What version of Filemaker are you using?

G

In article <1173134115.421805.140580 (AT) j27g2000cwj (DOT) googlegroups.com>,
"Kevin Audleman" <kevin.audleman (AT) gmail (DOT) com> wrote:

It depends what you're trying to do with that "list" once you've got it.

The simplest way to display a list is to use a Portal with that field
in it.

If you want the list to use as a pop-up menu (for example), then you
can define the Value List that uses the Relationship link to obtain
it's values from the other table's field.

If you need the list for some other strange reason, then you can still
use the Value List approach, and then create a Calculation field that
retrieves those values using the ValueListItems function (in the Design
Functions section).
eg. For FileMaker 5:

ListItems Calculation, Text Result, Unstored
= ValueListItems("Database Name", "Value List Name")


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)