Can anyone help me with a script to connect dynamically created table rows/fields to an ODBC database (MS Access)? For example a table with multiple fields for Customer Name, Phone Number, Address, etc.
I have several forms that I have connected static fields to MS Access but not dynamically created fields. I would use the FormID as the unique data point.
315 999 9999
127 Adtkins Dr, Liverpool, NY
215 888 4568
200 Block Ave, Hardrow, NJ
What I really need help with is a script to count the number of repeatable rows present and perform an action to each of those rows. To have the script count the number of instances of Row1 and then script that the rawValues of each field contained in the visible repeatable table1 Row1 equals the rawValues of the hidden repeatable table1 Row 1 that are bound to the database columns.