0 Replies Latest reply on Sep 14, 2018 2:02 PM by s_m

    Conditionally overlay a cell value and disable it in Tabular Form

    s_m

      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))
      1100TEST TEXT 1
      2200
      3300TEST TEXT 3

       

       

      Now, I have another table, Table B (sort of look up table)

      FID (NUMBER)LOOKUP_VALUE(VARCHAR2(20)
      100LOOK UP TEXT 1
      200LOOK 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.