Hi i have a requirement in my application
the below is the test data and the requeiment details
CREATE TABLE "DEPT"
( "DEPTNO" NUMBER(2,0),
"DNAME" VARCHAR2(14 BYTE),
"LOC" VARCHAR2(13 BYTE),
PRIMARY KEY ("DEPTNO");
SET DEFINE OFF;
Insert into DEPT (DEPTNO,DNAME,LOC) values (10,'ACCOUNTING','NEW YORK');
Insert into DEPT (DEPTNO,DNAME,LOC) values (20,'RESEARCH','DALLAS');
Insert into DEPT (DEPTNO,DNAME,LOC) values (30,'SALES','CHICAGO');
Insert into DEPT (DEPTNO,DNAME,LOC) values (40,'OPERATIONS','BOSTON');
in apex page i created two list boxes)
one is for dept no and another is for dname
requirement is once deptno is selected from the list item
IF selected choice is “10” or “20”, ask the following question: “Does deptno match the dname
- IF Yes, auto populate dname field to match deptno field.
- eg. 10 - Accounting
- 20 - Research and make the field disabled/readonly
- IF Not dept numbers are 10 or 20 then the dname list field to be enabled and able to enter manually
please advise i tried to create a dynamic action but no luck always the value of dname showing null.
thanks.