Combining multiple portal rows into one field

[micshrp]

I have a portal set up to track multiple presentation sessions by individual speakers (each record contains one speaker with the related presentations in a portal).

What I need is to combine the session names from multiple portal rows into one field for printing purposes. Each portal row contains 11 separate fields, but I just need information from one of the fields combined. How would one go about this?

Thanks in advance for any help provided.

Edited April 5, 2006 by Guest

[Jonathan9]

Not sure if this is the best thing to do, but if it's your requirement fair enough!

You could step through each portal row with a script. First create a new field to which to want the entire data to go into (let's call it NewField), and use a set field script step to add each line, e.g. Set Field (NewField) '= NewField & ", " & DataFromPortalRow' (then loop for each row until the end)

Or switch to a layout with these related records, find just the ones required, and step through each reocrd there doing the same.

Hope that makes sense!

[Søren Dyhr]

ValuelistItems( since you're on a pre fm7 version, could work as long as the field is unstored!

--sd