I'm trying to create a database with tables for customers, orders, payments and invoices. I've looked at existing template solutions and none really matches our needs. What's the best way to handle multiple orders (or payments) from a single customer, so they will show up in a list on an invoice (kind of like on a credit-card statement)? I can create orders linked to a customer, but then they only show up in an invoice-type layout when I view as a table, and I can't get a total to appear.
I guess what I'm after here is the best setup that will allow me to output something like this:
Order date/ description /amount
Another order date./ description/ amount
Total of amounts
Any advice much appreciated.