Existing subform data is being changed when new subform entries are added

Existing subform data is being changed when new subform entries are added

I'm having trouble with existing subform data being changed when new subform entries are created.

I have the following setup to track registrations for a girl scout troop:
  • Main Form: Child
  • Subform: Registrations
The data are a one-to-many relationship where each Child record has many Registrations (new Registration will be created for each year the child is in the troop.)

Per the instructions, I have created the subfom, added it to the main form, gone back to the subform and created the bi-directional lookup field based on the EXISTING relationship. 

With this setup I am able to add a new Child record (main form) and at the same time create a Registration record (or even multiple records) in the subform.
 

I can verify that all data is saved successfully when I view the reports for the main form and subform.




HOWEVER, when I edit an existing Child record (main form) and then try to add a new Registration record to the subform (within the main form view) all previously entered subform entries for that record are changed (they are unlinked from the Child's record).



Here's the result. Notice that only the Registration record I added last remains linked to the Child. The previous records are unlinked but remain in the Registration dataset.







In order to make sure there wasn't something wrong with my forms, I created another simplified form/subform pair following these instructions and I get the same behavior. 

Can anyone help me understand why this is occuring and come up with a solution to preserve original subform records after adding/updating a record?
    • Sticky Posts

    • Share your success story

      We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. Charles
    • Merge and Store v1 API depreciation

      Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operation
    • Zoho Creator Developer's Conference 2017 !!!

      We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders.       Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around