Update Table fields
Please Help !
I made a access db with following tables:
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