Beginner (We all started somewhere, right?)
Let's say I have two simple tables:
• Clients (Client ID, Client Name)
• Invoice (Client ID (related from Client), Client Name, product name, quantity, price, subtotal(=quantity*price) and Client Total (Summary = Total of subtotal)
On the invoice, I am getting the totals of ALL of the invoices from every client.:(
I want to show the total of all of a single client's invoices - I would like to show this not only on the client details page, but maybe on the invoice itself.
So, the invoice would have a total of the current invoice, and a "grand total" of all of the other invoices for that same client