I have a main form (Scheduler) and added a subform to it (Product_Subform).. I can create records to add an new appointment repeating every X weeks that matches an existing appointment... but I want to also duplicate the subform records in the new appointments that are being created.

Thanks,
Jason

2. //get current appointment record
3. myApptID = input.ID;
4. //repeat appointments
5. repeatInterval = input.Reoccurring_Appointment;
6. if(len(repeatInterval) > 0)
7. {
8. //get substring
9. repeatIntervalDuration = repeatInterval.subString(1,2).toLong() - 1;
10. if(repeatIntervalDuration = 2)
11. {
12. repeatIntervalDuration = 11;
13. }
14. //loop
15. //create number to loop thru
16. loop_list = {"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31"};
17. for each index myIndex in loop_list
18. {
19. if(myIndex <= repeatIntervalDuration)
20. {
21. //calculate weeks
22. daysToRepeat = (myIndex + 1) * 7;
23. // insert into scheduler form  *This is working* creates new records
24. recordID = insert into Scheduler
25. [
26. Client=input.Client
27. Appointment_Type=input.Appointment_Type
28. Practitioner=input.Practitioner
29. Practitioner_User_Filter=input.Practitioner_User_Filter
30. Ending_On=input.Ending_On.addDay(daysToRepeat)
31. Beginning_On=input.Beginning_On.addDay(daysToRepeat)
32. Added_User=zoho.loginuser
33. Map_URL=input.Map_URL
34. Map_URL_Client=input.Map_URL_Client
35. Full_Name=input.Full_Name
36. Visit_Notes=input.Visit_Notes
37. Email=input.Email
38. Client_Email=input.Client_Email
39. Entry=input.Entry
40. Total_Amount=input.Total_Amount
41. ];
42. // trying to add charges for each subform item - *This is NOT working - it creates records but they are not related to the appointment above - when I look at the appointment on those new records they don' t have any services listed like the original appointment has..*
43. myRecord = Scheduler[ID == myApptID];
44. for each  myField in myRecord.Services
45. {
46. insert into Product_SubForm
47. [
48. Added_User=zoho.loginuser
49. SchedulerLink=recordID
50. Product_Name=myField.Product_Name
51. Product_Quantity=myField.Product_Quantity
52. Product_Price=myField.Product_Price
53. Product_Total=myField.Product_Total
54. ]
55. }
56. }
57. }
58. }