I have a repeating table tied to a database connection. Upon first opening the form, there are no rows in the repeating table.
I have a secondary sharepoint data connection called "names"
The challenge:
When the form OPENS, I want to auto insert rows into the database connected repeating table based on the values in the secondary data connection.
e.g. secondary sharepoint data connection has the names, jim, bob, carly in it. When I open the form, I want the database connected repeating table to automatically insert 3 rows with the Name columnn defaulting to jim, bob and carly (one name for each row.)
I'd like to do it without code if possible.