I have a scenario like

                 Parent Form  -   Business_Date    (This form had " Customer" as subform) (Bi-directional Field - Bdate)

                 

                 Child Form  - Customer    (This form had " Business_Points" as subform)  (Bi-directional Field - Cname)

                 

                 

                  Grand-Child Form    - Business_Points

          So, coming to the issue i'm facing is that, when i simply update the  Business_Date form, all the existing relationship between  Customer and  Business_Points is collapsing.

           let me explain with screen-shots for better understanding.

            So, i have this data in  Business_Date View

            Now, i'm entering 2 values for "kmkr"

            This is  Business_Points view

            So, up to this, it is working excellent.

            Now, i'm simply updating following record in  Business_Date form.

           Now the existing relationship between  Customer and  Business_Points is collapsed.

            This is the problem i'm facing. Hope it is easy to understand, what i had explained.

      Regards,

      kmkr :)