how to reduce quantity
849238Dec 18 2012 — edited Dec 19 2012how to reduce quantity from one table due to other table
for exple.
i have a purchase a shampo in 20 quantity
and then sale this shampo 2 quantity
so i want now there should be 18 quantity of shampo in purchase table automatically
Purchase table
Product Id
Product Name
Quantity
SALE TABLE
Sale id
Product name
Quantity
Edited by: Hussain Afridi on Dec 18, 2012 4:27 AM