InfoPath Dev

I am using an autonum to create a key on a new record for me on all tables. I have a autonum field records 1 to 3283 on all three tables.  My main table have all fields with data in them.  My two child tables have the same autonum field filled in 1 to 3283 and also a Control Account Number field.  It looks like I did ...

I have done that, my Data Connection looks like this... -  LaborSummay.dbo     - LaborSummayCommentsLabor.dbo     - LaborSummayCommentsNonLabor.dbo   Autonumber is the primary key for all the tables and I have setup a relationship between the first table listed and the two below ...

My child tables do have a primary key and I have created a relationship between the parent and child tables(autonumber).  I used the data connection wizard to setup the new tables.  I also fixed some broken bindings. I can receive and submit to the parent table but unable to save to a child table even though I have it linked to the ...

I was splitting my Access table into three smaller table when I got your note. I now have a main table with most of the data and two other tables that contain Labor and Non-Labor comments. But when I add comments to the form it does not save it to the database. Also, when I try to add a new record I get the following error.. The following error ...

I am using Infopath 2003 so how is it done with this version?    

What is the right syntax to access use for the following Web Service data source in Jscript?   Code...I am getting an error on this var firstName = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/tns:UserInfoResponse/my:UserInfoResult/firstname").text Data Source...  myFields    ...

This worked great for Infopath 2003...thank you very much.   Now I would like to take the user ID and get User Name.  Looking into options.

I created two smaller tables but I have another problem now... I added a Where a clause and an Order By clause at the end of the SQL statement created by Infopath the query and it worked fine using one table as the Main Data Source.  But now that I am uisng 2 smaller tables, the query is using Shape Select with an Append Select and ...

NEVER MIND..FIGURED IT OUT!    I am converting an an Access database that I am using as a prototype to a SQL Database.  But I have a problem with the row size...it exceeds the maximum bytes allowed per role(8060).  My row size is (11733).  I use the table as an Main datasource wjich allows to me to read and ...

You are right...I am trying to access a data source record that is tied to a web service.  As you can tell, I need a better understanding of how to setup my definitions.  I have attached what my data source looks like to make it easier for you to see what I need.  Thanks for all of youe help!