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, 200619 yr by Guest

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!

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

--sd