Hello,

I have a database that has a relationship to sales data. Basically you have a product layout with a portal to all the sales to that product such as sale_date, Sale_QTY, and Sale_Amount. There could be more than one sale for each item.

When I do an export it will only list the most recent sales data from the portal. How do you export to excel the item an then fill in the cells for all the sold data from the portal.

Thanks for your help.

export the records from the related table. (the sales table) You could use the go to related record script step and say show only related records. Then export the data from the layout representing the sale data.