I tried searching for this topic, but couldnt find anything that I could use. I have an Infopath 2013 form, which pulls some vendor name and number info from a sql server (about 65000 records). I originally had this connection automatically connecting, but because of the size of the database - I am doing a manual query.
So I have a field - VendorSearch, on each line of the repeating table, where user will enter a vendor name. The search will look up records in the SQL DB - and give a pull down list. The first line works perfectly. Problem happens when I add a new line - the query is stuck on the first search. I would like to requery the data for the new info user will need.