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 :: 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

Re: Reduce QTY 4rm purchase tbl due to sold prodct fro sale Tbl [message #557897 is a reply to message #557895]

Sun, 17 June 2012 05:37

John Watson
Messages: 8938
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read
You probably want to creatge a trigger,
http://docs.oracle.com/cd/E11882_01/appdev.112/e10766/tdddg_triggers.htm#BABIEDEF

Report message to a moderator

Previous Topic:	open file .fmb
Next Topic:	How to retrieve records from SCOTT.EMP table, without using data block wizard?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 21:49:07 CDT 2024