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.

ADVERTISEMENTS

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.




 
 Subscribe for updates via RSS or Email

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.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners
InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013
InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners
InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010
InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers
InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services


Related InfoPath Articles:

ADVERTISEMENTS

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services