Prerequisites

Steps to follow

1. Navigate to the report of Form A in the edit mode of the application. Configure an action item with the name 'Copy Subform' for a single record by creating a workflow and adding the following Deluge script to the workflow. When this action item is triggered, it will open Form B and populate the ID of the selected record to the ID Number field in Form B.
   
1. //Configure an openURL task to open the 'Form B' and populate the ID of the selected  record in the ID Number field of the 'Form B'.
2. openUrl("#Form:Form_B?ID_Number="+input.ID, "same window");
2. Add the action item to the quick view layout of Form A's report to access it as a button from the quick view of Form A's report.
   
   
3. Create a new workflow to execute on load of Form B with the record event as Created. This workflow will fetch and populate the subform data from the From A.
   
   
4. Click Add New Action > Deluge Script and add the following script to the Deluge editor.
   
1. if(ID_Number != null)
   
2. {
3. //Fetch subform data of the selected record in 'Form A' by matching the autopopulated ID in the ID Number field.
4. fetch_records = Form_A[ID == input.ID_Number].Subform_A;
5. //Create a collection to hold subform rows.
6. rows_collection = Collection();
7. //Iterate through the each subform row in the 'Form A' to fetch and assign values from Subform A in 'Form A' to the Subform B in 'Form B'.
8. for each data in fetch_records
9. {
10. subform_row = Form_B.Subform_B();
11. subform_row.Single_Line_B = data.Single_Line_A;
12. subform_row.Number_B = data.Number_A;
13. rows_collection.insert(subform_row);
14. }
15. //Insert the subform rows stored in the collection to the 'Subform B'.
16. input.Subform_B.insert(rows_collection);
17. }

See how it works

Related links

1. Insert rows in Subform
   
2. Create Action Item
   
3. openUrl