View Single Post
  #1 (permalink)  
Old December 5th, 2004, 01:42 PM
karajian karajian is offline
Registered User
 
Join Date: Dec 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Update Table fields

Please Help !
I made a access db with following tables:
Producs
Orders
OrderDetails
Customers
I can't update the stock field of products table when input a new order from orders form. For Example
I have a stock of 15 pcs for a product.A customer orders 5 pcs of this product.I am searching a way so when I input this order (in orders form) the stock field of table Products updates to 10 pcs(15-5)
I tried several ways to solve this problem (Vba ,Sql) but nothing.
I appreciate if you help me
Thank you in advance
P.S. If this help I can tell you more details or send a demo of my db

Reply With Quote