Home » Developer & Programmer » Forms » Reduce QTY 4rm purchase tbl due to sold prodct fro sale Tbl
Reduce QTY 4rm purchase tbl due to sold prodct fro sale Tbl [message #557895] Sun, 17 June 2012 04:18 Go to next message
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
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 Go to previous message
John Watson
Messages: 4553
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
Previous Topic: open file .fmb
Next Topic: How to retrieve records from SCOTT.EMP table, without using data block wizard?
Goto Forum:
  


Current Time: Tue Sep 16 11:21:35 CDT 2014

Total time taken to generate the page: 0.13859 seconds