Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using cg$ctrl value to limit LOV

608596Apr 18 2008 — edited Apr 23 2008
Hi all

Is there a way of capturing and holding a parent value of one item selected in an LOV to restrict the list of values in another LOV?

Currently I am passing the parent value to cg$ctrl item but have no idea how to capture the value in a variable so that I can use this to restrict the other LOV with current, as well as new records.

I have checked that the cg$ctrl has a value by displaying a message in new-record-instance trigger and it does have a value only after selecting a new value for the first LOV.

Parent value shows null when just scrolling through records, i.e. how can I get the parent value of the current record LOV item into cg$ctrl??

Thanks for any input.

Andy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2008
Added on Apr 18 2008
3 comments
946 views