email found set

[rservis]

I have a portal on one of my customer databases, shown on this portal is various items ie: title, description, etc.. What I want to do is email a complete list of items the customer will recieve in the message body, I have built a script that finds the found set of records from the related file and I have a summary field which shows all data from one record using the trim (field) in one field but unable to create a field which shows the summary data from all found records so I can use this field in the send mail script.

[jscooper]

I would use a script. Loop through all Customers. For each customer, go to the related records (showing only related records). Then in the items file, loop through, building a concatonation of all the items (separated by commas, returns, whatver) into a global field. Copy this value back to the main file and add it to your email body text.

Jeff