Calculation: concatenated field from related records

[Marek P]

Hi,

I'd like to create a calculated field (in FM8) that will contain a text string made up of concatentated strings from one field in all the related records (in one particular relationship).

For example, if I had a people table, and a related cat table. I'd like a field in the people table that might say "Felina+Boots+Cooper+" for a person with those three cats.

I'm not concerned about the delimiters.

It seems like it should be easy, but it hasn't been.

Thanks,

Marek

[LaRetta]

Hi Marek,

Create a value list of your cat table, using values from fields and only related values (to people). Then calculation (text, unstored) in people with:

Substitute(

ValueListItems(Get(FileName) ; "thisNewVL" ) ; ¶ ; ", " )

)

This will produce Felina, Boots, Cooper

[Marek P]

Hi LaRetta,

It works. Thanks!

Marek