InfoPath 2003 Repeat values from secondary data source

J

Jazz

Hi!
Help please!
I'm developing InfoPath form for editing data in MS SQL Server 2005
DB.
I have table (t1) with data and view (v1) which calculates special
values for each row of table.

I want to display in repeating InfoPath table data from t1 and
corresponding values for each row from v1 with ability to edit data in
t1.

When I select data from t1 and v1 in other SQL view and set it as Main
data source in InfoPath I can't submit data.

When I set t1 as Main data source I can't attach data from v1
(Secondary data source) to each row in repeating table. Field from v1
displays value only from first row of v1, but not changes it for each
row.

Could someone help me, please?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
secondary data source/sharepoint library 0
S.Y.M. Wong-A-Ton .... PLEASE HELP, I Need your INFOPATH 2013 COOKBOOK 2 1
Secondary (receive) data connection with File Attachment 1
Copy data from SharePoint list to InfoPath Form 0
Query SQL Secondary data source 3
Repeating Sections/Table with dynamic Lists from Web Services 0
XDocument Object - Where has it GONE! 1

Top