Grouping related records in a portal
I have one file - 'FOH Log' which tracks daily attendances for various activities and generates a daily report, plus another file 'FOH Sales' which records daily sales of merchandise.
In FOH Sales, I've set up a typical Invoices....Lineitems....Products scenario, and have put a portal on the FOH Log Daily Report to FOH Sales to display products sold that day, linking on invoice date. Because we sell a few of the same item, I'd now like to group the items within the portal. Is that possible?
screenshot of portal as demo