Text Summary Field

[gesualdo]

I want to create some sort of summary field that will combine information from a given field from all records in a found set. I see where it's possible to create such a summary using numbers, but is there a way to create this for text. (I'm trying to create an e-mail list of all records or for a found set)

[FUBAR]

Depending on what you want to do this can be done a few different ways...

A value-list will give you all of the different records in a certain field but it will be all records instead of just your particular found set.

A value-list and a self-relationship could give you all of the different records in a certain field and can only include the ones in your found set.

Or there's always looping through all of the records in your found set and continuing adding text to a global field (usually not a particularily good solution, but a solution none-the-less.)

Hope this helps.

[wwyngaard]

You might want to check out www.troi.com. They have a plugin that does sum of text via relationship. I have used it in many solutions and it really works well. In a found set you could do a self join and some the text from the set.