Using cg$ctrl value to limit LOV
608596Apr 18 2008 — edited Apr 23 2008Hi 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