How can I merge multiple portal records into a single field?

[HALBURN]

I have three separate portal rows with values like this:

Apples

Oranges

Grapes

I am trying to create a calculation that returns this:

Apples,Oranges,Grapes

Can someone please point me in the right direction? I am sure that there is an existing thread here that cover this but I cannot find the darn thing.

[Matthew F]

I think Filemaker is somewhat limited in this regard. This is kind of a hack, but you could define a Value List ('fruit') to represent the field that you want to consolidate (to include only related records). Then use a calculation to display the list:

Substitute ( ValueListItems ( Get ( FileName ) ; "fruit" ) ; "¶" ; ", " )

Consolidate.fp7.zip

[bruceR]

If the portal TO name is fruits:

Substitute( List( Fruits::fruitname); ¶; ", " )

[HALBURN]

Thanks guys, that worked great.