-
When a new record is added on the main table, InfoPath will default a new record for each child. The user can complete these, ignore these, or add more than one. That is why the records need an ID as well as a pointer to the parent, to enable multiple children. A new record would need the pointer set to submit properly but it would be ...
-
That may be the issue.
InfoPath typically wants a one to many relationship, multiple children per parent or at least the capability to handle this. I would try adding a Primary key which is unique to each child and see if that works.
-
Typically you would configure each table with a primary key so that each record has a unique ID. Child tables would have an extra column/field which pointed to the parent record in the parent table.
So main
ID Name Decription etc
1 Test ...
-
Alright.
First I would try adding a new view and drag your whole data node onto it as a sectio with controls so you can see everything.
Preview and see if you can query and submit all three tables. One thing do you have any data in your tables? Often I have an issue with the data connection if the table has no records (1 ...
-
In the data connection wizard have you added the additional tables?
On the right side once you select the main table you need to add the additional tables. You should see all three tables and the field selection in the tree view.
Then you will have al three tables in your data source. When you insert it will insert one of ...
-
The child tables would have to have to have primary keys and also key relationship to the main table.
You would also need to go through the data connection wizard and modify your main data source to alert it to the data change. This will probably break some bindings on your form so you will have to do some clean up of the data if the ...
-
I am not sure exactly how you are doing it but you would want to create an InfoPath form which can display your Word data. Do you have this?
Once you have a couple of these saved then you should be able to merge them into one ideally. Then you could export to Excel.
If you want to attach a sample to your post ( under the options ...
-
You would need to investigate on Microsoft's site.
If I remember right, the 2003 version is harder to find. It was included before but now they are pushing the 2007 version.
-
Hey Osama.
I have not done it myself but there should be tutorials available on publishing a browser based form. All of them must be done via an administrator on the Sharepoint backend. I would search around and I am sure you can find one.
-
I believe there are two different VSTO versions, one for 2003 and one for 2007. I think you might have installed the wrong one.