Fill editable table using SQL data - InfoPath Dev
in

InfoPath Dev

Fill editable table using SQL data

Last post 06-01-2010 10:12 AM by aruna akella. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-31-2010 06:41 AM

    Fill editable table using SQL data

    Hello

    First I'm using InfoPath 2007.

    I have created a SQL view that list workflow tasks (task type, dates and status)

    I have created a data connection that point to this view.

    On that point my form can get SQL data, but how to display them in a table ?

    I want let user performed their own planning in an InfoPath form.

    How can I fill a table with all these tasks details and let user modify task date ?

    thanks in advance

     

     

     

  • 06-01-2010 10:12 AM In reply to

    Re: Fill editable table using SQL data

    Use a repeating table and bind it to your secondary data source (in this case, it's your SQL table). To do this follow these steps:

    1. Add a repeating table.
    2. Right click on the repeating table, and select 'Change Binding...'.
    3. Select secondary data source, and select the table name and click next.
    4. Select the columns you want to show in the table. Click Finish.

    Hope that helps!

    Aruna Akella
    Qdabra® Software / InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.