1 Reply Latest reply on May 23, 2017 2:33 PM by eudriscabrera-JavaNet

    How to save data in Master-Detail tables with seq PKs  in Java?


      Hello Experts,


      I'm building a Sales Order application.


      And now i'm stuck in how to save the sales Order.


      I know how to insert records in a single database table ... but now i want to save in both tables.

      I want to insert a record in the master SalesOrder table and the items in the detail SalesOrderItems at the same time.


      The Primary keys in both tables are assigned using a database sequence so i don't know how to handle the relation between them

      There is no way to know the SalesOrder (Master)'s PK to assign as a FK in the SalesOrderItems (Detail) table at the time i'm saving the data.


      Is this possible?


      Thank you for your time