Home » Developer & Programmer » Forms » Selection Limit on block (10g)
icon3.gif  Selection Limit on block [message #551475] Wed, 18 April 2012 10:13 Go to next message
vinni
Messages: 34
Registered: March 2012
Member
This will probably be the last topic that i post.
I have a question regarding a selection limit from a list of values. The table where my IDs (unit_codes) come from has another column called 'points'. each ID has its own number of points.
Is there a way to put a selection limit on the display field that points will be placed on?

FOR EXAMPLE: a course block has a selection limit of 70 points, A person named someguy selects :
music = 20 points
maths = 20 points
mathsXTRA = 40 points
**ALERT!!! - U can ONLY select 70 points worth of units**

[Updated on: Wed, 18 April 2012 10:23]

Report message to a moderator

Re: Selection Limit on block [message #551514 is a reply to message #551475] Wed, 18 April 2012 14:27 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't think that LoV is capable of doing that, but you might create a summary item (create an ordinary text item; open its Property Palette window. Interesting stuff is under "Calculation"). If you are doing it for the first time, I'd suggest you to open Forms Online Help and read about "summary items" (because it might be tricky to correctly set it up).

[Updated on: Wed, 18 April 2012 14:28]

Report message to a moderator

Re: Selection Limit on block [message #551581 is a reply to message #551514] Thu, 19 April 2012 08:53 Go to previous messageGo to next message
vinni
Messages: 34
Registered: March 2012
Member
Understood. Managed to get a running total on the Item. So on the next step would i need to set a WHEN-VALIDATE-ITEM Trigger?
Re: Selection Limit on block [message #551614 is a reply to message #551581] Thu, 19 April 2012 12:03 Go to previous message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, I think it would be your next move.
Previous Topic: Cann't commit form when form status change from New to Query and to Changed
Next Topic: FRM 40735 When Button Pressed Trigger Raised Unhandled Exception ORA 04062
Goto Forum:
  


Current Time: Fri Jul 05 21:21:50 CDT 2024