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

    Nederlandse Hulpbronnen


      • Recent Topics

      • Allow SO Item table to search other fields in items to make entry easier

        We have thousands of items, some of which need to be entered on the fly by desk people. We don't want abstracts like the vendor's part number in our SKU or Item name. It would make order entry much easier if the context search in the items table would
      • Zoho Inventory Amazon Integration

        The Zoho Developer Account is not valid for Amazon UK and returns this response whilst set up: This Developer Account Number 861444729264 is not valid for the GB marketplace
      • Sales by Customer

        Hi There, I am looking to generate a report that shows the total value of the sales made to our customers, but does not show each transaction i.e. Customer A = $100,000 Customer B = $50000 and so on This is based on a "Closed Won" in the Deals Module.
      • Enhance Bot Functionality for Scheduled Reminders

        Dear Zoho Cliq Team, We are writing to request an enhancement to the bot functionality within Zoho Cliq. Currently, bots can be added to channels and send messages, but they lack the ability to schedule reminders. Our team utilizes a deluge code to send
      • Zoho Expense - Update Expense Report through web API

        Hello, I am currently having issues updating fields in expense reports (not individual expenses) through the API as described in the API documentation. When I make that request using the invokeAPI Deluge function, I receive a response from the API saying
      • How to switch templates in Zoho Commerce

        I have set up a template in Zoho Commerce and would like to change it. How do I do this?
      • How to use filters on all products page? Or even a category page?

        Hello, I am trying to create some filters so users can use filters to find products they are looking for. So what i am trying is to create a filter according to price lets say. So if i define it this way i am expecting to see this filter option on category
      • How to show product categories on side menu?

        Every time I add a category it appears on the main menu. I would like the main menu for things like contact us, blog etc.. and a side menu to the left of the screen for product categories. How do I make them appear in a side menu or even in a category
      • How to Add Custom Sections in the Product Page?

        Hi Zoho team, I’m currently using the Tranquil theme on Zoho Commerce and I have a question regarding the product page layout. Right now, under each product, I can see expandable sections like Product Details and Specifications. I’d like to add two additional
      • Unable to validate DMARC for the email

        I have recently started to use the ZOHO CRM tool and I'm currently on free trial period. However, when I tried to test the email, it was landing in SPAM or JUNK folder of the recipient's inbox. I learnt about the DMARC, so i have completed SPF and DKIM
      • Migrating Shopify Customers and Tags to Zoho Commerce

        I’m exploring options for migrating our existing Shopify customer accounts into the Zoho Commerce member portal. Specifically, I have a few questions: API Availability: Is there a public API or supported endpoint that allows us to import Shopify users
      • Multilingual website feature

        Would be a great feature to have. I saw that this feature was available for backstage. I think it could be done for zoho sites too.
      • Feature Suggestion for Zoho Social: Auto-reply to Comments or Keywords

        Hi Zoho team, I'd like to suggest a very specific feature that would be extremely helpful for customer engagement: the ability to automatically send a reply to comments on posts — either all comments or those containing specific keywords. For example,
      • How Can i Add Email campaign for my UAEVisaOnline.center website

        Hello Team, i want to create email campaign for our website https://www.uaevisaonline.center but can't able to add. Its showing error like please try after some time. Can you please help and solve the issue. Thanks!
      • The domain Etihaduaevisa.com which you have entered belongs to a different deployment/region

        Hi Team, I am trying to set up a business email account to Zoho for www.etihaduaevisa.com but it doesn't allow me There is a message that pops out The domain which you have entered belongs to a different deployment/region Kindly assist me with this. Thank
      • Outlook not recognising Zoho Inbound server

        I have been receiving my ZOHO emails using MS Outllok on my iPhone and PC, but since Friday 2nd May, incoming emails are not arriving via Outlook and I get the error message saying the server is 'not responding'. Have ZOHO changed the settings for the
      • Zoho Sign / CRM integration - stop unsigned documents being attached

        I'm using the the CRM/Sign integration to send documents for signature from Zoho CRM. I noticed that an unsigned copy of the document is added as an attachment in the CRM. Is there a way to stop this? I only want signed documents to be attached. The unsigned
      • Resend invite

        Hi, How do I resend an invitation to someone who didn't get the invite the first time around? I tried going to Setup-->User (like it says in the Help) but there was no option to resend. It doesn't display any users who has not accepted the invitation.
      • Asking for implementation roadmap or step-by-step guidelines

        Hello everyone, I'm a freelancer who's been hired to implement Zoho CRM for a client, and I want to make sure I approach this correctly. Could someone kindly share a comprehensive implementation roadmap or step-by-step guide that covers all the essential
      • Asking for implementation roadmap or step-by-step guidelines

        Hello everyone, I'm a freelancer who's been hired to implement Zoho CRM for a client, and I want to make sure I approach this correctly. Could someone kindly share a comprehensive implementation roadmap or step-by-step guide that covers all the essential
      • Approval Workflow for Purchase Orders Abrir

        The requirement is , that all purchase orders greater than or equal to 5000 go through an approval process from certain people, but within books I only see that the approvers can be by levels or any approver but we cannot enter a rule like these. Can
      • Multiple subforms from same existing form

        Hello, In an Order form, I have a subform for Line items. But my items have 5 distinct product categories. To make it pleasant and easy to use, I want to repeat the subform 5 times in the same parent form, to separate my 5 categories of product. But I
      • Announcement: Zoho DataPrep 1.0 will be deprecated on January 31, 2026

        We'd like to inform you that the Zoho DataPrep 1.0 version will be officially deprecated as of January 31, 2026. This aligns with our efforts to streamline and improve your overall experience with Zoho DataPrep 2.0 which was released in Sep 2024 . To
      • Discussions from Ask the Experts 19 : Inside Zoho Desk Spring Release 2025

        Hello Everyone, We appreciate the engaging discussions during the Ask the Experts 19 session on the Spring Release. It was a pleasure connecting with you. Our team is actively working towards your requests to deliver an improved experience. In this post,
      • Optimisez la gestion des bots et la conformité à Apple MPP

        Filtrage des bots : une nécessité pour des données marketing fiables Les indicateurs de performance sont au cœur de toute stratégie marketing. Cependant, l’augmentation du trafic généré par des bots ainsi que l’adoption croissante de fonctionnalités comme
      • One time batch workflow to repair omission of data

        Hi, I created a parent form (Product) and another form (Prices) that is used as subform in the parent form. In the parent form I have a field Category that must appear in the subform, but I forgot to create the field at first in the subform and now I
      • Advance Your Churn Predictions with Zia's Usage Data Feature: Event Mapping

        Greetings all, This is an important and exciting update about feeding usage data into Zoho CRM. To expand the scope of how usage data can be used by Zia, we are introducing a new section called Usage Data under Zia. Users can now easily import, edit,
      • Web-To-Quote form would be awesome

        It would be awesome to be able to embed a quote form on a website and have that filter in to Zoho CRM. Account Number to match the Account in Zoho Email address could match the Contact. Product Code could be required to match the product. Not sure about quantity? I am sure this all could probably be done via the API and maybe some middleman interaction with Creator, but it would be nice if it was as easy as the Web-to-Case form. Something like this could lead to further integration with CMS and Shops
      • Published Sheet - Share option to show "Save copy to WorkDrive"

        Hi Sheets Team, I'm currently working on a Zoho Sheet which I want to share with other Zoho users outside of my organisation. Normally I would do this with Google Sheets but I'm trying to make better use of my Zoho tools. When I share a Google Sheet publicly
      • Bills vs. Expenses

        Hi eveyone, Can somebody explain me a little bit better of how can I use Bills and Expenses in my business? I don’t understand their differences to be honest.
      • Integration to LinkedIn Recruiter

        We'd like you to support Recruiter System Connect to sync our LinkedIn Recruiter candidates to the Zoho Recruit ATS. How can we do this?
      • List View just got a makeover!

        Hello everyone, The new list view is being rolled out in phases and will be available to all our users by the end of January 2021. We are excited to announce that the list view in modules is set to get a new look. The new list view is sleek, contextual,
      • Add Video block needs improvement

        I regularly send out links to videos in my campaigns and I find that built in video block is never good enough to use in my campaigns, so I have to make a thumbnail in Canva and upload it or screenshot the actual video on YouTube. The concept of the video
      • Profile cannot add tasks, calls or meetings

        Good morning, I have a Profile of users that's called "Standard2" and their module permissions are set as follows: Despite this, one of my users on the Standard2 profile gets this when they try to add a call: Any idea how to fix this? If i bump them up
      • Zoho Developer Community Monthly Digest – April 2025

        Hello everyone, Welcome to this month’s Zoho Developer Community Digest! We’ve lined up an exciting series of technical sessions, product deep-dives, and community conversations to keep you informed and inspired. Don’t forget to check out our resource
      • Dataprep est-ce que zoho est sérieux ??

        Nous venons encore de passer plus de 2 heures avec le support zoho qui est incapable de résoudre le problème rencontré dans la mise en place d'un pipeline de données entre le C>>RM et DataPrep Celà fait 5 mois que nous essayons de faire fonctionner le
      • STOCK COUNT - How is this even possible

        Dear Zoho One, We have a lot of products from Zoho but I really don't understand this. We mainly use ZOHO FSM with ZOHO INVENTORY because we are in service and maintenance for electric charging stations for cars All employees of Zoho FSM have their own
      • Changing sequence of buttons

        How can I change the sequence of these buttons? I want the 'Versturen referral campagne' to be displayed as the default button
      • Unapproved Articles for Review?

        What is this feature and how do I use it? I'm not seeing any option to mark articles as unapproved and needing review.
      • Trying to fetch related list data from deals module

        I need to fetch stage history data which comes in related list in deals module using coql. How can I achieve that? { "select_query": "SELECT Technical_Survey_Date as system_order_confirmation_date, Stage,Created_By, Latest_Quote_Creation_Date,Originating_Source,
      • Next Page