Update a SharePoint list from two different SharePoint lists
I have an online SharePoint list which I would like to get updated by another SharePoint list.
In my App which is connected to a SharePoint list called Latent Defect Tracker. When I submit the date this list gets updated from my forms Pending Latent Defect and Pending Latent Defect_2 all contained in one SharePoint list (LATENT DEFECT TRACKER)
I have a gallery called Gallery3 where I can select the data and edit the form.
I have now added a third form called 'Defect Type and Sub Type' this form has a second data source (SharePoint list) called Defect Type and Sub Type. I have created this second list as I am using cascading dropdowns (Category and Sub Category).
On preview, the form looks good and I can select all the field items and cascading dropdowns work.
When I submit the form I need it to update the SharePoint list 'Latent Defect Tracker' with the data from all three forms and the data from the second SharePoint list 'Defect Type and Sub Type'
In the SharePoint list 'Latent Defect Tracker' I have added columns for Category and Sub Category. (Not sure I need these)