Oracle Apex 21.2.
I have 3 tables
1. DEPT
DEPT_ID DEPT_NAME
------- ----------------------------------------
10 TAXATION DEPARTMENT
20 QUALITY CONTROL DEPARTMENT
2. EMP
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------------------- --------- --------- ------
No records.
3. EmpView
EMPNO ENAME JOB MGR HIREDATE DEPTNO
----- ---------- --------- ----- ----------------------- ------
7369 SMITH CLERK 7902 17/12/1980 20
7566 JONES MANAGER 7839 02/04/1981 20
7782 CLARK MANAGER 7839 09/06/1981 10
7788 SCOTT ANALYST 7566 19/04/1987 20
7839 KING PRESIDENT 17/11/1981 10
7876 ADAMS CLERK 7788 23/05/1987 20
7902 FORD ANALYST 7566 03/12/1981 20
7934 MILLER CLERK 7782 23/01/1982 10
8 rows selected
Oracle Apex, Editable Interactive Grid have 2 regions,
Region1 => Region have one Page Item name **TDeptNo** and One Button Name **GetValues**.
Region2 => In the 2nd region I Created an Editable Interactive Grid , source table is EMP, Primary key is EMPNO.
I want when I enter deptno 10 in page item TDeptNo and click on GetValues button,
it fetch all the records from EmpView where deptNo= 10 and copy into an interactive grid. after that I will Enter SAL and COM amount and will save this interactive Grid.
How can achieve this in Oracle apex.