Best way to create this layout
I have a fairly standard invoicing solution. 3 basic tables; customers, invoices, and line items. I would like to create a layout (not a report) that lists all the customers and the grand total of all their invoices. In the footer of the layout I would like to see the grand total of all the customers invoices.
I have come up with several ways of doing this with summary fields and portals. The problem is with 20k customer records and 80k invoices in our database the performance of my answer has a lot to be desired. I have a feeling this can be done using multiple table occurrences and complex relationships which should drastically improve the performance but I can not quite get it to work. Any ideas?
ps FM 12