Solved

Setting infopath drop down list boxes to equal different fields from one selected item

Posted on 2010-11-16
2
396 Views
Last Modified: 2012-05-10
Hi all, not sure if this is possible, but I require the following:

I have two drop down list boxes that are conntected to the same SharePoint list called 'Approvers.' In the approvers list there are two columns: Name [people field] and E-mail [text] The data connection called Approvers is linked to these two fields

What I require is that when a name is selected in the first drop down list, populated from the Name column, the corosponding email address for the name is shown in the second drop down list. I have a broswer enabled form so filtering is not allowed

0
Comment
Question by:DJSharepoint
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 15

Accepted Solution

by:
melli111 earned 500 total points
ID: 34146028
You can filter it by a rule instead.  What you do is add a rule to the dropdown that contains the manager's name.  Select "Set a fields Value".  For the field to set, select the dropdown that contains the email addresses.  For the value select "insert field or group", select the email field from the sharepoing list, then click the filter button, and select in the first dropdown box of the filter dialog the dropdown field that contains the manager's name (from the form); then in the second dropdown select "is equal to" and in the third dropdown box select the manager's name field from the sharepoing list.
0
 

Author Closing Comment

by:DJSharepoint
ID: 34146184
Wow, that's some filtering but works a treat!

Thanks bud, you're an InfoPath Genius!
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

695 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