OraFAQ Forum: Forms » Reduce QTY 4rm purchase tbl due to sold prodct fro sale Tbl

Home » Developer & Programmer » Forms » Reduce QTY 4rm purchase tbl due to sold prodct fro sale Tbl

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Reduce QTY 4rm purchase tbl due to sold prodct fro sale Tbl [message #557895]

Sun, 17 June 2012 04:18

pakpolic@gmail.com
Messages: 23
Registered: June 2012
Location: Peshawar

Junior Member

Sir i want to reduce my product quantity automaticaly from Purhasetable by to sold this product 4rm SaleTable.
exmaple

Purchaetable saletable
1.purchaseid 1.saleid
2.prodid 2.prodid
3.quantity 3.quantity
4.date 4.date

for example first i buy soap 30 quantity using purchase table and then sold this soap 5 quantity using sale table.
Now i want to update my soap quantity 25 in purchase table automatically...
send in example in FMB file..
hussainkhan201@yahoo.com

Report message to a moderator