I have MS Access databases:
DB Clients - ID, Client
DB Orders - ID, Client, OrderTotal
DB Payments - ID, Client, PaymentTotal
In DB Orders and Payments, the column Client is drop-down list from which I can select one of the clients from the Clients DB.
Everything is good until now..
I created query ClientsDuty, which show every client's OrderTotal, PaymentTotal and SumOrderTotal-SumPaymentTo
tal.. it looks like this:
CHRIS, 480$, 400$, 80$
Now I need to add a button next to all client, which when you click it to show all of the orders that the client made.. example:
When you click on CHRIS's Payments buttons to show:
I uploaded a screenshot also.