Posted By: emily |
5/31/2006 2:40:00 PM |
|
|
If I’v two tables with their values: cars(carNo,name,color,model,existquantity) 2- CustomerOrders(orderNo,carNo,ordered,orderedquantity,orderdate)
I made for each one of them a form by the Windows Form Designer in the vb.net plate to record data through these forms.
By the way I’m working on an Access db and on the (imports system.data.oledb provider).
How can I make the( existquantity) column in the “cars” table decreases for each ordered car according to the (orderedquantity) column from the “CustomerOrders”table.
Because I need to make a report displaying the cars and their remaing quantity(existquantity).
Pleeeeeeeeeeeeese help me,for I’m still a student ,and any kind of help is a lesson for me.
Thanx..
Emily
|
|