SQL Database Integration

Re: Auto populate - only adds data from first row in SQL database

Hilary Stoupa — Thu, 22 Sep 2016 14:55:26 GMT

Wonderful, glad you have it sorted out!

Re: Auto populate - only adds data from first row in SQL database

frymic — Thu, 22 Sep 2016 12:32:10 GMT

Good morning, Thanks for replying so quickly. I think I solved the problem I was having. I was working with an old form and repeating table so I needed to bring in a new repeating table from the secondary data connection.

Re: Auto populate - only adds data from first row in SQL database

Hilary Stoupa — Wed, 21 Sep 2016 23:58:24 GMT

So - what is your current logic / rules setup? Can you attach a copy of your form under the Options tab in a reply?

Auto populate - only adds data from first row in SQL database

frymic — Tue, 20 Sep 2016 20:00:16 GMT

Good afternoon, I am trying to develop a form that can pull data from a SQL Server secondary data source to populate a Client Info section (Client ID, Name, Phone, etc...) and then from there have a their order appear in a Repeating Table. The client section will currently populate with only the first row of information in SQL. When I try to query for a different record no records appear. I have been able to get the repeating table to filter the data to show only the individual client's order but do not know if this is causing a problem with the client section. I have read this post (http://www.infopathdev.com/forums/t/8421.aspx?PageIndex=1) but the methods here do not seem to work with SQL only Access and Sharepoint. Any help would be greatly appreciated. Thanks