summing text from portal

[archives8]

Ok, I'm stuck with a portal related problem.

I have a portal thats displaying textual IDs from another table. There are up to ten related records being returned for each record in my database. I need to get all information out of each related record summed together into a single field in the database.

For example, in a record in the database I have IDs from four related records in seperate portal rows 0027s1, 0027s2, 0027s3, and 0027s4. I would like this to become one single field that [0027s1 0027s2 0027s3 0027s4].

I have no problem summing togther numeric and date information, but am having no luck figuring out how to do this with text. Is this possible without having to trigger a script, I'd really prefer this to be automated?

thanks ahead

_don

[-Queue-]

Create a value list based on the related ID field and an unstored text calculation of Substitute( ValueListItems( Status(CurrentFileName), "id value list" ), "

[archives8]

Thanks for the tip, I guess I meant 'agregate' not 'sum', sorry it was tough to get my thoughts down correctly after banging my head against my desk this morning. I much more lucid at the present time.