5 Replies Latest reply: Mar 29, 2013 5:24 AM by O.Developer RSS

    Master detail detail relation

    MST
      Hi,

      I have 3 tables.
      C_ORDR_HDR --> A
      C_ORDR_DTL --> B
      C_ORDR_SCHDLE --> C.

      In A, B, C tables
      A is Master, B is chield in A, B tables
      B is Master, C is chield in B, C tables.

      For single transaction in C_ORDR_HDR multiple items in C_ORDR_DTL.
      For single item in C_ORDR_DTL table multiple schedules in C_ORDR_SCHDLE.
      First i enterd data in C_ORDR_HDR after i entered data in C_ORDR_DTL with on row after i entered multiple data in C_ORDR_DTL. then i am going to C_ORDR_DTL to enter second item then it is asking Do you want save.

      Please how to avoid the this problem.

      Without using POST.
        • 1. Re: Master detail detail relation
          Andreas Weiden
          Without using POST you would have to store all the data "in memory" and build up the synchronization on your own. thats lot of work if at all possible.
          Another way would be to use temporary tables, always post the table and write them back to the "original" tables at the end of your transaction (but again, there is a post in it).
          • 2. Re: Master detail detail relation
            MST
            Hi,

            I am new to oracle forms.
            Please can u explain clearly
            • 3. Re: Master detail detail relation
              Andreas Weiden
              Which option?
              • 4. Re: Master detail detail relation
                HamidHelal
                MST wrote:
                Hi,

                I have 3 tables.
                C_ORDR_HDR --> A
                C_ORDR_DTL --> B
                C_ORDR_SCHDLE --> C.

                In A, B, C tables
                A is Master, B is chield in A, B tables
                B is Master, C is chield in B, C tables.

                For single transaction in C_ORDR_HDR multiple items in C_ORDR_DTL.
                For single item in C_ORDR_DTL table multiple schedules in C_ORDR_SCHDLE.
                First i enterd data in C_ORDR_HDR after i entered data in C_ORDR_DTL with on row after i entered multiple data in C_ORDR_DTL. then i am going to C_ORDR_DTL to enter second item then it is asking Do you want save.

                Please how to avoid the this problem.

                Without using POST.
                check this.. Remove Do you want to change



                Hope this helps

                Hamid
                • 5. Re: Master detail detail relation
                  O.Developer
                  I have 3 tables.
                  C_ORDR_HDR --> A
                  C_ORDR_DTL --> B
                  C_ORDR_SCHDLE --> C.


                  Hi

                  You have table and having master detail relationship among each one.

                  Did you created mast detail relation in Block A - With Block B as Details

                  In Block B Creation master detail relation with Order_Schdle as detail.

                  If this relationship established on form, then system will not ask for commiting.

                  If still you have doubt, post same here