hello every
hope everyone is doing well
so it happened that i work with oracle form 6
what i want to do is
i have a coulmn called work place
have the whole name of the work plave in the company
what i did is divided it as the following
select
regexp_substr(work_place,'[^/]+', 1, 1)
as "dep1"
,regexp_substr(work_place,'[^/]+', 1, 2)
as "dep2"
,regexp_substr(work_place,'[^/]+', 1, 3)
what i want to do now is
to make a form with three item list
dept1
dept2
dept3
where each one wholds its own dept
so when the user whatever dept1 the list change depands on that partucler dept1
what should i do