InfoPath 2010 master detail example
This article shows an InfoPath 2010 master detail example that makes use of an InfoPath master detail control to present data that has a one-to-many relationship.
You have a database or an XML file that contains a large amount of related data that has a one-to-many relationship, and you want users to be able to use an InfoPath 2010 master detail control to make it easier to present the data on the form.
An InfoPath 2010 master detail control is actually two controls in one, or more precisely, two related controls. The InfoPath 2010 master detail control is not available for InfoPath web browser forms in SharePoint.
However, there are several techniques you can use to create your own master detail functionality without having to use the standard InfoPath 2010 master detail control. The discussion of alternatives for InfoPath 2010 master detail functionality in SharePoint is beyond the scope of this article.
The InfoPath 2010 master detail example given below shows you how you can place the standard InfoPath 2010 master detail control on an InfoPath Filler form. It also shows you how you can connect an InfoPath repeating table with an InfoPath repeating section and relate them to each other to get the same functionality as that provided by the standard InfoPath 2010 master detail control.
Note that since an InfoPath 2010 master detail control always has a repeating table as the master and either a repeating table or a repeating section as the detail control, you can use a combination of two repeating tables or a repeating table and a repeating section when manually setting up controls to provide master detail functionality.
The key to connecting controls to provide master detail functionality is to use the main repeating group node for both the master and the detail control, and assign a key to the master control, so that the detail control can refer to it.
The following InfoPath 2010 tutorial video shows you two ways to set up master detail functionality for an InfoPath 2010 form that is based on an XML file.
Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.
Related InfoPath Articles:
- What is an InfoPath repeating table?
- Master/detail across views
- InfoPath demo: Master/detail across two InfoPath forms linked through one field
- Connect InfoPath master detail to SQL Server Express
- Connect SharePoint form library form to SharePoint list form through SharePoint web part connections