Home » Developer & Programmer » Forms » Change the total based on the checkbox value (Oracle Forms 10g)
Change the total based on the checkbox value [message #588327] Tue, 25 June 2013 01:10 Go to next message
Messages: 1
Registered: June 2013
Junior Member

I have created a custom form which fetches certain records. There is a column called invoice_create_flag which is check box. By default when we query this form, value of check box is 'Y'. Another column is Amount.

Initially when form is called, all the records are selected. Hence it should show the total of all the records.

Now If the users unchecks any record, System should deduct the amount of that particular record from the total amount.

Could anybody help me to achieve this functionality.

Attached is form screenshot for reference.
Re: Change the total based on the checkbox value [message #588401 is a reply to message #588327] Tue, 25 June 2013 10:16 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How do you calculate the total amount? Manually, or is it a summary column? If "manually", you might use WHEN-CHECKBOX-CHANGED trigger (and add/subtract amount to/from total amount. If you used a summary column, I *think* (don't have Forms here - you'll know better as soon as you check its Property Paletter) you can't include any condition in there so you'd need to switch to a manual option.
Previous Topic: Opening different forms in Same frame
Next Topic: Trigger program to track user information
Goto Forum:

Current Time: Tue Aug 22 17:45:58 CDT 2017

Total time taken to generate the page: 0.04975 seconds