Hi,
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 |
2 | 200 | |
3 | 300 | TEST TEXT 3 |
Now, I have another table, Table B (sort of look up table)
FID (NUMBER) | LOOKUP_VALUE(VARCHAR2(20) |
---|
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.