0 Replies Latest reply on Aug 10, 2018 3:10 AM by user5108636

    Interactive Grid Select List

    user5108636

      Hi All,

            Using APEX 5.1.4. I have a IG with a select list which is a lookup from the PRODUCTS table. The display and return value of select list is <product_id>-<product_name>

       

      In the select list based on products table the user sees e.g. 15 - CHIPS

       

      Depending upon user input, I then update/insert values from IG into another table CUSTOMER_ORDERS which also has the corresponding fields prod_id and prod_name.

       

      The default save button of the IG throws error saying cannot insert NULL into prod_id field. The process in Interactive-Grid Automatic Row Processing (DML).

       

      How do I customize the save functionality in the IG to accommodate this use case. i.e. splitting the two fields and saving it in separate columns in the CUSTOMER_ORDERS table.

       

      P.S. I am working with a legacy DB Schema, and do not have the convenience to redesign it. Have to work with what I got.

       

      I certainly would have designed it in a different way.

       

      Please advise

       

      Thanks