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

InfoPath Dev

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

Last post 09-22-2016 07:55 AM by Hilary Stoupa. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 09-20-2016 01:00 PM

    • frymic
    • Not Ranked
    • Joined on 09-16-2016
    • Owen Sound
    • Posts 2

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

    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
  • 09-21-2016 04:58 PM In reply to

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

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

    Hilary Stoupa

  • 09-22-2016 05:32 AM In reply to

    • frymic
    • Not Ranked
    • Joined on 09-16-2016
    • Owen Sound
    • Posts 2

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

    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.
  • 09-22-2016 07:55 AM In reply to

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

    Wonderful, glad you have it sorted out!
    Hilary Stoupa

Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.