Home -> Usenet -> comp.databases.oracle -> Oracle Power Objects-Combo Box-ValueList

Oracle Power Objects-Combo Box-ValueList

From: Larry M. Jones <ljones_at_mindseye.berkeley.edu>
Date: 1995/08/19
Message-ID: <4159ot$69c_at_agate.berkeley.edu>#1/1 






Can anyone tell me how to reference a field from a parent form in the 
where clause of a combo box valuelist in an embedded child form in OPO?  
I'm used to being able to do the following in the list of values in forms 
3:



select child_table.column1 from child_table
where child_table.column2 = :parent_block.field



I haven't found any way to reference the value shown in the parent form 
from a combobox ValueList in an embedded child form.  It looks as if



=select ... where child_table.column2 = frmParent.field_name.value



ought to work, but the string frmParent... seems to be being passed to 
the server rather than the actual value of the parent field currently 
showing on the form.



Thanks for any help or suggestions.
Received on Sat Aug 19 1995 - 00:00:00 CEST












Original text of this message