?
Solved

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

Posted on 2010-11-16
2
Medium Priority
?
400 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 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
The Summer 2017 Scholarship Winners have been announced!
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

765 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