Learning how to use nested, dependent controls in InfoPath 2010 makes sense. In fact, these controls are a popular feature of lots of different types of forms. Video tutorials present an excellent method of achieving this training objective. SharePoint-Videos dot com offers a video tutorial on this subject, “Use cascading drop-downs in InfoPath to display parent-child information”. This video is part of our Video Training Curriculum on InfoPath 2010. Access to this set of videos is limited to subscribers to all of our web site content, as well as to individuals and/or organizations who opt to purchase our DVD SharePoint Designer 2010 Workflows Training DVD. We recently reviewed this video tutorial as part of our process of going through each of our video tutorials from the perspective of a business user.
The intended audience for this video tutorial are administrators, developers, architects for SharePoint 2010 enterprise. This video tutorial can also prove to be useful for the same set of users for SQL Server 2008 R2 and later. All of these users will most likely have a ready understanding of the software development concept of “parent child” relationships between pieces of data, whereas business users will likely find this concept to be challenging. This video tutorial requires access to a running SQL Server instance, which is why we did not step through the procedures for our SharePoint Online E3 plan account. In fact, we do not have access to SQL Server for this blog.
As our instructor, Asif Rehmani points out, some familiarity with the Microsoft SQL Server Management Studio is required if one wishes to replicate the procedures demonstrated with a local InfoPath 2010, SQL Server, and SharePoint set of running services. As well, access to Microsoft’s demonstration data, “Adventure Works” will be very helpful, which already contains the nested database tables which are used in this training video.
Anyone following this video will quickly pick up that the real work of establishing the interconnected relationship between categories, sub categories and products that is demonstrated in this training is actually accomplished at the database level. We simply connect our control to the SQL Server Database and, specifically, the actual table that is already populated with nested subordinate tables. It needs to be noted that we do demonstrate how a user can actually select which column data is included in the InfoPath when connection to this remote data source is established. In sum, though the data sources are, in fact, hierarchically dependent, the actual connections at the level of the InfoPath 2010 form are discrete.
If you would like to learn further about how to use this tutorial within your specific training requirement, then we would like to hear from you. Please contact us by telephone at +1 (630) 786-7026. Alternatively, you can contact us by email with any questions you may have about this video, the InfoPath 2010 set, and possible applications for individual as well as organizational-level viewing and use.
As ever, use this link to place an order for an annual subscription to SharePoint-Videos instructional content
© Rehmani Consulting Inc, all rights reserved