one of this columns is from type "popup key lov (named lov)". the user has to choose a room-number in this column. after that the next column should be a select-list. this select list are a result from the column before with the room number.
how can i change the second select list that it show only the sample space from the first popup key lov, not more, dynamic?
select desk_nr d, desk_id r
where room_id = ***value_of_first_column***