2 Replies Latest reply: Mar 14, 2013 10:41 AM by 988448 RSS

    Apex Form Master/Detail it's possible with PK's database?

    988448
      I've searching abou an OBE or another example to create and form with PK from database or the way is create only with sequence?

      My tables are:

      Master:

      ID_ROL (PK)
      NAME


      Detail:

      ID_ROL (PK)
      USER_ASSIGN (SECOND PK)

      How i can assign the Key to the next ID_ROL (Detail) in run time?

      Thanks,
        • 1. Re: Apex Form Master/Detail it's possible with PK's database?
          AndyPol
          Hi

          Your question is about basic oracle sql/plsql knowladge. You have to read about it first then Apex development.

          In oracle for populate ID you can use sequence (name_sequence.nextval).
          insert into your_table (ID, COL1) values (name_sequence.nextval, 'your data');

          regards
          • 2. Re: Apex Form Master/Detail it's possible with PK's database?
            988448
            Thanks Andy,

            I know pl/sql.

            I was reviewing examples of PL / SQL and applied generally use keys with fields sequences and not from table base fields.

            Not if it's something special in APEX or if it's okay to use as a base table field keys. Why try to make a simple example form master / detail this turned complicated. Especially when I have to assign the key to the field of the detail table (autogenerated). I don't know how do it.

            thank you very much