InfoPath Dev

Please see the image of InfoPath 2010 from http://postimg.org/image/88dfdc7kf/

1. The form has three sections(1,2 and 3) as highlighted with blue boxes.
2. Data of each section will be saved in three different SharePoint 2010 lists.
3. Data of Section 1 must be saved in the list List_TRFs this list has a primary key ID.
4. Data of Section 2 must be saved in the list List_Allocated_Budgets so that ID of List_TRFs must also be saved as foreign key with each repeating table value.
5. Data of Section 3 must be saved in the list List_Destinations so that ID of List_TRFs must also be saved as foreign key with each repeating table value.

 What we need:

              We need a complete CRUD(Create, Read, Update and Delete) code to manage this form.

User will only see the List_TRFs when he edit the list item, a complete from as shown below must be presented to him, with relevant Budget codes and destinations automatically populated from relevant lists , as a complete from so that he can edit and update the form.

Hi A.Ishaq,

Your link doesn't show an image.

But, anyway, you can map sections to lists using several techniques: CAML, qRules, and possibly BCS.

There are many resources here and on the web. Please take a look at qRules SubmitToSharePointList. Qdabra did a webinar recently showing how to use CAML to do the same thing (out-of-box).

There are many tutorials on MSDN that also show you how to use BCS.

Please do a little search - there's lots of stuff out there.

Thanks!

Hi Patrick ,

I really appreciate such a quick response. 

I am sorry if the the link does not show an image , please click the following link for the image http://postimg.org/image/88dfdc7kf/

I am able to add repeating table data to a list with custom code, but don't know how to populate the repeating table with the list using code.

Any help would be greatly appreciated.

Best regards.

Hi again,

You don't need code to populate the repeating table. You can use default values as well.

I'm attaching an example CopyRepeating.xsn that shows two techniques:

1. Default data - you add rows to your main data source and then use the side-effect of setting a column to trigger rules on the rows to copy from the secondary data source
2. qRules Insert - this is our common code library that inserts rows into your main data source and then has the same side-effect as in #1

We used to respond to individual write-code-please requests, but stopped doing it since there were so many. Now, we just tell people to use qRules. qRules free trial exists and the price is low. All proceeds go to supporting this forum.