How to make LOV's reference other LOV's on the form page
I Have 2 LOVs I'm working with here:
LOV#1: (Works fine because the value of :P10_ID_LOCATION is passed in from the Report Page)
This is the Description ov LOV#1:
select a.room_no, a.id from p_closets a,p_buildings b where a.bldg_id = b.id and b.id = :P10_ID_LOCATION
....
LOV#2: (I cant get it to restrict the returned values by reading the value selected in LOV#1)
This is the Description of LOV:
select a.name, a.id from p_devices a, p_buildings b, p_closets c
where
a.bldg_id in (b.id) and b.id = :P10_ID_LOCATION
and
a.clst_id in (c.id) and c.id = :P10_ID_CLOSET
....
I'm relatively new to OAX and this is my first time using the FORUM.
If anyone can help me with this LOV dilema I will greatly appreciate it.