steps to Join Two List Parent Child Relation in infopath and sharepoint





Actaully I have infopath list forms and infopath forms does not allow to access Query string parameters of the pages on which they are placed. I have also tried to submit data from infopath 2010 list form to another list using web service (Lists.asmx) but I have failed (I am still need some help on this).
Ok, let’s talk about the solution that how we can get Query string parameter in infopath 2010 form:
  • Sharepoint 2010 have filter webparts that allows you to filter the page content by applying them, so I have use “Query string filter” webpart and set the properties of the Query string filter (Query string Parameter = <your parameter name>) .
  • Filter Webparts could also send the data to different webparts placed on the same page. It can be done by selecting the filter webpart and use “Connections” and send the Query string data to the infopath form webpart. One thing here, in the connection dialog, you would not see lookup columns i.e. if you have made a lookup column which points to the parent List then this column would not be visible in connection dialog, so you have to make a “single line of text” column in the child list and select it in connection dialog. You can hide this field from the List form and from the List Views.
  • Once you get the Query string parameter value in text field, you can copy it to the lookup column by using infopath rules.

Comments

Post a Comment

Popular posts from this blog

C# - Changing controls properties in other forms in C#

Image
The controls you add to a form have something called Properties. A property of a control is things like its Height, its Width, its Name, its Text, and a whole lot more besides. To see what properties are available for a button, make sure the button is selected. If a control is selected, it will have white squares surrounding it. If your button is not selected, simply click it once. Now look in the bottom right of Visual C# Express, just below the Solution Explorer. You should see the Properties Window.
Read more

Displaying Message Boxes in C#

Image
A MessageBox is a predefined dialog box that displays application-related information to the user. Message boxes are also used to request information from the user. To display information to the user in a message box Navigate to where you would like to add the code for the message box. Add code using the MessageBox.Show method. The following code demonstrates how to call the Show method of the MessageBox class to display information to the user. The call to the Show method uses the optional style parameter to specify the type of icon to display in the message box that best fits the type of message box being displayed:  public void PerformCalculations()  { // Code is entered here that performs a calculation // Display a message box informing the user that the calculations // are complete MessageBox.Show ("The calculations are complete", "My Application",  MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk); } Message boxes can also receive input. The Show method o...
Read more

How to set value of a field from sharepoint list

Image
Download infopath form coding at  here Designing  and coding infopath Article 1:  How to code C-Sharp on infopath form 2010 Article 2 : How to set the value of a Field in Infopath Article 3 : How to set value of a field from sharepoint list Article 4 : Populating InfoPath Drop Down List Box with SharePoint List Lookup Data  Article 5 :  Populating InfoPath Drop Down List Box with SharePoint Fields Choice Article 6 : Deploy an InfoPath 2010 Form with Managed Code to a Browser Enabled Sharepoint Document Library In article  How to set the value of a Field in Infopath  we learn how to code basic infopath, now we continue code to get data from sharepoint list then display to fields of infopath form Open Infopath | Design user interface follows as Go to File => Form Options => Programming Form template code language: C# Ads not by this site Go to File => Form Options => Security and Trust Conf...
Read more