
10-20-2005, 02:48 AM
|
|
SEO Junior
|
|
Join Date: Oct 2005
Posts: 2
|
|
|
Add a record to Access Database
Hello guys! I am not familiar with ASP (used to work with VB), but I need to add a few things in a code i am runing on the website. The issue is: I have a shopping cart with Access db. I have orderID for every order but I need to add InvoiceId to Completed orders. I have a page where I can change status of the order (in dropdown box).
When I change a value in drop down box to "Completed" and press "Submit" it should write a record in table Invoices: InvId, OrderID, InvDate. Where InvID is autonumber, OrderID is completed order number and Date is Now.
Can somebody help me with it? I really don't know where to start.
Thanks a lot in advance.
|