auto-fill a repeating table from SQL, on form open using QueryDB questions. - InfoPath Dev
in

InfoPath Dev

auto-fill a repeating table from SQL, on form open using QueryDB questions.

Last post 04-10-2013 10:20 AM by Doreen. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 04-09-2013 11:31 AM

    • Doreen
    • Top 50 Contributor
      Female
    • Joined on 08-11-2010
    • Federal Way, WA
    • Posts 291

    auto-fill a repeating table from SQL, on form open using QueryDB questions.

    I want to auto-fill a repeating table from SQL, on form open. 

    1. Is this possible using technique in Qdabra tutorial titled "Copy Sql value to infopath repeating section fields using QueryDB"?

    2. What I'm proposing is using a repeating table instead of a repeating section - is that possible?

     3. If it is possible, is it better practice to place the repeating table inside a static section control, or to place the repeating table directly on the canvas? (The reason I ask is because I have multiple sections,  or tables on the form, that need to auto-fill based on other conditions in the SQL table, like their category value and sort order)

  • 04-10-2013 08:21 AM In reply to

    Re: auto-fill a repeating table from SQL, on form open using QueryDB questions.

    Yes, it is possible. For the purposes of the tutorial or the form logic, a repeating section is no different than a repeating table. The only difference between those two is in the canvas.

    It's always best practice to place your repeating tables/sections within a section control.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 04-10-2013 10:20 AM In reply to

    • Doreen
    • Top 50 Contributor
      Female
    • Joined on 08-11-2010
    • Federal Way, WA
    • Posts 291

    Re: auto-fill a repeating table from SQL, on form open using QueryDB questions.

    Thanks, now I have peace of mind that I'm designing it correctly. :)
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.