Re: Using SQL: Master-Child

Home Forum Parent-Child Forms Using SQL: Master-Child Re: Using SQL: Master-Child

#5761

If I understand your issue correctly, you need to send all of the data in a form table to a SQL DB. You can use table column – all rows in a connection as a send parameter. If that works – great, but it may not be in a very usable format for you.

Another option is to create a behavior to loop through each row of a table. When you get to the next row you can either use a connection to send the data from that row, or you can put the data into hidden fields to send when you reach the bottom of the table. If you do a connect between each row it may slow your performance. If you use hidden fields it limits the number of rows you can send to SQL by the number of hidden fields you create.

Workflow software, Process software, Procedure software