APEX

Hi gurus of Apex world,

what I'm trying is that:

I have a select list based on LOV which can be updated without problems by changing the value of its parent select list:


with one parent select list:

Cascading LOV Parent Item(s): P15_DEPTNO

List of values definition:

select m.m_vorname||' '||m.m_nachname d, m.m_id r
from mitarbeiter m
where m.a_id = :P15_DEPTNO
order by 1


with another parent select list:

Cascading LOV Parent Item(s): P15_KW

List of values definition:

select distinct m.m_vorname||' '||m.m_nachname d, m.m_id r
from mitarbeiter m, bericht b, kw k
where m.m_id = b.m_id
and b.kw_id = k.kw_id
and k.kw_id = :P15_KW
order by 1

both works well as single parent, but I would like to implement both as parent, so i tried:

Cascading LOV Parent Item(s): P15_DEPTNO,P15_KW

select m.m_vorname||' '||m.m_nachname d, m.m_id r
from mitarbeiter m, bericht b, kw k
where (m.a_id = :P15_DEPTNO)
and (m.m_id = b.m_id
and b.kw_id = k.kw_id
and k.kw_id = :P15_KW)
order by 1

The rusult is that the select list reacts just to one parent - P15_KW

What am I doing wrong?

Any help would be apreciated!