Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Problems with "SubForms" in InfoPath 2010

Posted on 2012-08-15
Medium Priority
Last Modified: 2012-08-29
I got me a form

My form what post to my SharePoint Document list

I get me some data from that list for my DropDown.

I can even see what the ID of the selected item is (visible in the attached PDF in the
"Supervisor First Name" field). What I am having trouble with is retrieving
additional data about that record based on the ID selected. I'm not sure if I
should be using the [External Item Picker] control, or if I should be doing
something with the [Query using a Data Connection] rule action.  As you
can see in the [Supervisor Name] field, I am viewing the [Full Name]
field, which is simply the concatenated [First Name] and [Last Name] fields.
The "Value" of the DropDown list is the ID of the record. What I want to
happen is, the [Supervisor First Name] and [Supervisor Last Name] fields
populate with the respective values when the Supervisor is selected. Any
help you can give would be greatly appreciated.
Question by:Rahsaan-Pringle
LVL 28

Accepted Solution

Clay Fox earned 1500 total points
ID: 38299141
This is referred to as a "cascading dropdown"

If you search on www.infopathdev.com you can find plenty of examples.

You also are going to need to learn filtering, this is part of it.

Author Comment

ID: 38306008
Thanks, ClayFox, you put me in the right direction. I went on to make a little set of ScreenShots that give better detail than what I found. This one focuses on the repeating tables. The next one I do will focus on individual fields that aren't connected to a repeating table.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question