Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

Access query

Hi!

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-SumPaymentTotal.. it looks like this:

Client,Orders,Payments,Duty
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:
CHRIS, 60$
CHRIS, 20$

I uploaded a screenshot also.

Thanks!

screenshot.png
0
QuantumBG
Asked:
QuantumBG
  • 2
  • 2
1 Solution
 
Easwaran ParamasivamCommented:
Hi,

 Could you please more details whare is the front-end you use to develope?

 If it is an ASP.NET application to use the MSACCESS database, then Grid can have button columns by using <Template column> and the Bubble event handling can handle the event in Serverside.

Please refer below links for more details:
http://msdn.microsoft.com/en-us/library/aa984252(v=vs.71).aspx
http://www.dotnetjohn.com/articles.aspx?articleid=45


Regards,
Easwaran.
0
 
peter57rCommented:
Do you have a form that shjows a list of orders (for all clients) - if not create one.

Then re-do you Show order button, add it again using the controls wizard and this time say that you want to 'open the form and find specific data to diaply'.  You will then be able to link the forms using the client field in the next step of the wizard.
0
 
QuantumBGAuthor Commented:
Yes, I've done that one time, but it's not showing a list of the clients.. it's showing one by one client and I need to move between them with < and > :(
0
 
peter57rCommented:
I don't understand your response - what is not showing a list of clients?


This is what you said you wanted...
"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."
0
 
QuantumBGAuthor Commented:
Oh yes yes I didn't understand you..
It worked now!!
Thank you so much!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now