Pull (Parent Form) variable into (Sub Form) as the function iterates through recordset??

Pull (Parent Form) variable into (Sub Form) as the function iterates through recordset??

Hi guys,

I need to update just over 23,000 records from 2023. I may be overthinking this; however, as you can see, I've added a single criteria to the function and initially designed it to run on the click of a single record. I would be there for years lol!

I would like to execute the function and insert entries into the subform (sampleSizeCheckStage1) and take the  sampleID from the Parent Sample Form (frmSample) so it links back to its parent form. Am I even looking at this correctly or am I totally missing a trick?

Any help on this would be so appreciated as I'm really struggling to get my head around it. Many thanks in advance for any help given.

  1. void processSizeCheck(int sampleID)
  2. {
  3. for each  r in frmSample <<< Parent
  4. {
  5. // Sample Form
  6. sizeCheckS1Complete = true;
  7. // Size Check Form
  8. sizeCheckForm = insert into sampleSizeCheckStage1 <<< Subform
  9. [
  10. sample_id=sampleID << need from Parent above
  11. sizeCheckTechnician=thisapp.GetEmployeeCombinedName()
  12. Added_User=zoho.loginuser
  13. xTT1="Pass"
  14. xTT2="Pass"
  15. xTT3="Pass"
  16. xBT1="Pass"
  17. xBT2="Pass"
  18. xBT3="Pass"
  19. xRT1="Pass"
  20. xRT2="Pass"
  21. xRT3="Pass"
  22. xLT1="Pass"
  23. xLT2="Pass"
  24. yLT3="Pass"
  25. xOutcomeResult="Passed"
  26. yTT1="Pass"
  27. yTT2="Pass"
  28. yTT3="Pass"
  29. yBT1="Pass"
  30. yBT2="Pass"
  31. yBT3="Pass"
  32. yRT1="Pass"
  33. yRT2="Pass"
  34. yRT3="Pass"
  35. yLT1="Pass"
  36. yLT2="Pass"
  37. yLT31="Pass"
  38. yOutcomeResult="Passed"
  39. bmsBF1="Pass"
  40. bmsBF2="Pass"
  41. bmsTF11="Pass"
  42. bmsTF2="Pass"
  43. bmsOutcomeResult="Passed"
  44. flatnessTT1="Pass"
  45. flatnessTT2="Pass"
  46. flatnessTT3="Pass"
  47. flatnessTT4="Pass"
  48. flatnessBT1="Pass"
  49. flatnessBT2="Pass"
  50. flatnessBT3="Pass"
  51. flatnessBT4="Pass"
  52. flatnessRT1="Pass"
  53. flatnessRT2="Pass"
  54. flatnessRT3="Pass"
  55. flatnessRT4="Pass"
  56. flatnessLT1="Pass"
  57. flatnessLT2="Pass"
  58. flatnessLT3="Pass"
  59. flatnessLT4="Pass"
  60. flatnessOutcomeResult="Passed"
  61. perpTT="Pass"
  62. perpBT="Pass"
  63. perpRT="Pass"
  64. perpLT="Pass"
  65. perpendicularityOutcomeResult="Passed"
  66. outcomeResult="Passed"
  67. ];
  68. }
  69. }

    Access your files securely from anywhere

        Zoho Developer Community




                                  Zoho Desk Resources

                                  • Desk Community Learning Series


                                  • Digest


                                  • Functions


                                  • Meetups


                                  • Kbase


                                  • Resources


                                  • Glossary


                                  • Desk Marketplace


                                  • MVP Corner


                                  • Word of the Day



                                      Zoho Marketing Automation


                                              Manage your brands on social media



                                                    Zoho TeamInbox Resources

                                                      Zoho DataPrep Resources



                                                        Zoho CRM Plus Resources

                                                          Zoho Books Resources


                                                            Zoho Subscriptions Resources

                                                              Zoho Projects Resources


                                                                Zoho Sprints Resources


                                                                  Qntrl Resources


                                                                    Zoho Creator Resources



                                                                        Zoho Campaigns Resources


                                                                          Zoho CRM Resources

                                                                          • CRM Community Learning Series

                                                                            CRM Community Learning Series


                                                                          • Kaizen

                                                                            Kaizen

                                                                          • Functions

                                                                            Functions

                                                                          • Meetups

                                                                            Meetups

                                                                          • Kbase

                                                                            Kbase

                                                                          • Resources

                                                                            Resources

                                                                          • Digest

                                                                            Digest

                                                                          • CRM Marketplace

                                                                            CRM Marketplace

                                                                          • MVP Corner

                                                                            MVP Corner





                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now