Combining values of fields in found set

[deego55]

Is there a way to create a field that combines all the values of another field in all of the records in the found set? For instance, a field that contains the value of PhoneNumber for all the records in the set. So if there are 12 records the field would combine all twelve phone numbers.

[BobWeaver]

Maybe. If you can mathematically define how you get your found set, then you can create a calculated field with the formula, and then a selfjoin relationship. You can then create a value list based on the relationship and use the ValueListItems function to retrieve the set of data.