I am on Application Express 5.0.4.00.12 & Oracle DB 12C Enterprise Edition.
I have a situation.
I have a tabular form on, lets say Table A. Only TEST_VALUE is editable in the tabular form.
|SID (NUMBER)||FID (NUMBER)||TEST_VALUE (VARCHAR2(20))|
|1||100||TEST TEXT 1|
|3||300||TEST TEXT 3|
Now, I have another table, Table B (sort of look up table)
|100||LOOK UP TEXT 1|
|200||LOOK UP TEXT 2|
My issue is, I need to overlay "TEST_VALUE" field with the "LOOKUP_VALUE" content based on the FID available and then make it disabled.
So in this case, first and second rows (SID = 1 & 2) in the tabular form will have the column "TEST_VALUE" overwritten with the values from "LOOKUP_VALUE" column from Table B and then they are disabled.
But the 3rd row (SID = 3) will have the column "TEST_VALUE" displaying TEST TEXT 3 and will be editable since it doesn't have its corresponding FID in the Table B.
Is there anyway we can do it.
Thanks in advance.