Thank you @Steve. I was able to break this up using two tasks in the MonthlyReport workflow. The reason I had to break it up was because one task is already a sequence of actions and apparently you cannot have an action that is a ‘sequence of actions’ with an action that is another ‘sequence of actions’.
So workflow task1 is the sequence of actions task in MonthlyReports table, then I initiate task2 which is a separate ‘sequence of actions’ adding the row into WaterUseData table and then executing the ‘sequence of actions’ in WaterUseData table. Whew that was a mess.
Last part that I cannot figure out is I have a specific ending view (dashboard) that is supposed to show the newly created row in MonthlyReports table along with a detail view of the related WaterUseData row that was created in the previously explained steps. If I incorporate an action that links to a different view into my action sequence, then the workflow is unable to execute that action for some reason and if I choose the view as the ‘finish view’ from the MonthlyReports table form for some reason it does not navigate there either. Any ideas?