SQL Database Integration

Re: Fill editable table using SQL data

Aruna Akella — Tue, 01 Jun 2010 17:12:56 GMT

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!

Fill editable table using SQL data

denfer06 — Mon, 31 May 2010 13:41:34 GMT

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