Hi. 

We are trying to use workflow processes in a specific scenario. Our solution works in the following way. 

• A stored procedure will periodically populate  two Joget tables using the c_xxxx format  
  • App_fd_Header : Fields -  ID, c_hField1 , c_hHolder
  • App_fd_Detail : Fields  -  ID, c_dField1, c_dField2, c_dReason, c_dExplanation, c_FK
• For Example ID 
  
  • Record in table app_fd_header will be populated: ID =123489, c_hField1 ='abcde', c_hHolder = 'Dave'
  • Two records in app_fd_detail will be populate for fields ID, c_dField1, c_dField2 and the c_FK field will both have 123489 as the foreign key. 
• The intention is for the user to be provided with a list of  records matching his c_hHolderName and then for him to view the form using a spreadsheet grid for the app_FD_Detail related records. 
  • c_dField1 & c_dField2 are reason only. 
  • They need to complete for each record the Reason and provide explanation. 

With that scenario in mind, I have created a header form with a spreadsheet control working as required with the related detail . It works great, BUT it has not workflow. 

I would like to attach a workflow to it and I am battling to work out how to do this. In a nutshell , a user comes in and is presented with a list of payments pre-populated. I want the user to then complete some information at the detail level (may be some header level) and then submit it review into the workflow.