I am new to Oracle. My first project is to create a program that will allow users to select "promotional material" to be mailed to customers, and also keep track of the current inventory. I am using forms to do this.
The item number, items description and qty are all in a database. On my form I list the item and description and have another field that allows the user to enter how many of this item they would like mailed out to the customer. When they enter the qty they would like mailed out and hit submit, I would like to subtract this amount from the current qty. I have tried doing this and am having trouble. I'm not sure I understand which trigger I need to use, or how the triggers work. I have taken several classes, and have many books, but none have covered what I am trying to accomplish. If you have any information, please help.
Thank you!
The item number, items description and qty are all in a database. On my form I list the item and description and have another field that allows the user to enter how many of this item they would like mailed out to the customer. When they enter the qty they would like mailed out and hit submit, I would like to subtract this amount from the current qty. I have tried doing this and am having trouble. I'm not sure I understand which trigger I need to use, or how the triggers work. I have taken several classes, and have many books, but none have covered what I am trying to accomplish. If you have any information, please help.
Thank you!