Concatenation from related records

[danjacoby]

Short version: I need to create a field that concatenates info from a particular field in another, related file.

Long version: Two files, Main and Related, with a relationship based on Name field in both files. A field in Main ("Concatenation") needs to string together the contents of the "Info" field in all the related records in the "Related" file.

Any ideas?

TIA,

Dan

[BobWeaver]

Create a value list in your main file using "related values" from the info field in your related file. Then, in your main file, define your new calculated field as:

Valuelistitems("Mainfile","ValuelistName")&Left("",Count(RelatedFile::info))

The Left...Count... business is to ensure that the field updates whenever you change the related data.

[danjacoby]

A truly beautiful solution. Thanx muchly.

Dan