Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Course Of The Month
6 days, 16 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
InfoPath lookup field to SharePoint
Posted on 2012-12-25
I have a SharePoint 2010 list, EmployeeList. It has fields EmpNo and Department.
I have another list, Drivers in the same site and it also has EmpNo along with other informaiton.
I would like to create an InfoPath form to enter new drivers.
In it, I would like a drop-down for the DriverID field and a text box for Department. The driver id is the employee number. Therefore, the drop-down in DriverID should display all values from EmpNo in EmployeeList. In the form, as soon as I choose one employee number from the drop-down in DriverID, I want the Depatment text box to automatically populate with the corresponding department from EmployeeList.
How can I achieve this?
I have another list, Drivers in the same site and it also has EmpNo along with other informaiton.
I would like to create an InfoPath form to enter new drivers.
In it, I would like a drop-down for the DriverID field and a text box for Department. The driver id is the employee number. Therefore, the drop-down in DriverID should display all values from EmpNo in EmployeeList. In the form, as soon as I choose one employee number from the drop-down in DriverID, I want the Depatment text box to automatically populate with the corresponding department from EmployeeList.
How can I achieve this?
[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
-
3
2
6 Comments
You need to research "cascading dropdowns" and filters.
Good examples at www.infopathdev.com
You will create a data connection to the drivers list
Set up 2 dropdowns
have the second dropdown use the driver list
But have a filter so that empid equals the field of the first dropdown.
Good examples at www.infopathdev.com
You will create a data connection to the drivers list
Set up 2 dropdowns
have the second dropdown use the driver list
But have a filter so that empid equals the field of the first dropdown.
When you get to infopathdev.com search on cascading dropdowns, or you can on any search engine.
I am on my phone at the moment but there are several good tutorials.
I am on my phone at the moment but there are several good tutorials.
Active 5 days ago
Hello,
I don't know why you don't want to click a link to another web site, but if you insist:
In the InfoPath form, create a new data connection to receive data and point it to the Employee list. Make sure to include the fields for EmployeeID and Department. Give it the name EmployeeList
In your main data source, you need a field for DriverID and one for Department.
Drag both fields to the form.
Change the DriverID control to be a dropdown. Edit the control properties and click "Look up values from an external data source".
In the Data Source field, select the EmplyeeList data connection.
Set both the Value and the Display name to be EmployeeID and close the dialog.
Create an action rule on the DriverID field. The rule should fire whenever the field is changed.
Create an action to set another field's value.
Select the Department field in the Main data source as the field to be changed.
In the Value box click the formula button. In the next dialog click "Insert Field or Group".
Select the EmployeeList data source, open the Data Fields node and click on "Department" and then click the button "Filter Data". In the next dialog click "Add".
In the Filter dialog, set the first value field to EmployeeID of the EmployeeList data source: click "Select field or group", select the data source EmployeeList, open the Data Fields node and select the field EmployeeID.
Set the comparison operator to "is equal to".
Set the second value field to DriverID of the Main data source: click "Select field or group", select the Main data source and select the field DriverID.
Click OK on all the dialogs.
cheers, teylyn
I don't know why you don't want to click a link to another web site, but if you insist:
In the InfoPath form, create a new data connection to receive data and point it to the Employee list. Make sure to include the fields for EmployeeID and Department. Give it the name EmployeeList
In your main data source, you need a field for DriverID and one for Department.
Drag both fields to the form.
Change the DriverID control to be a dropdown. Edit the control properties and click "Look up values from an external data source".
In the Data Source field, select the EmplyeeList data connection.
Set both the Value and the Display name to be EmployeeID and close the dialog.
Create an action rule on the DriverID field. The rule should fire whenever the field is changed.
Create an action to set another field's value.
Select the Department field in the Main data source as the field to be changed.
In the Value box click the formula button. In the next dialog click "Insert Field or Group".
Select the EmployeeList data source, open the Data Fields node and click on "Department" and then click the button "Filter Data". In the next dialog click "Add".
In the Filter dialog, set the first value field to EmployeeID of the EmployeeList data source: click "Select field or group", select the data source EmployeeList, open the Data Fields node and select the field EmployeeID.
Set the comparison operator to "is equal to".
Set the second value field to DriverID of the Main data source: click "Select field or group", select the Main data source and select the field DriverID.
Click OK on all the dialogs.
cheers, teylyn
Featured Post
Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
- Microsoft Applications
- Windows OS
- Fonts Typography
- Web Browsers
- Microsoft Word
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Suggested Courses
Course of the Month6 days, 16 hours left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
Earn Certification
MCSA Configuring Windows 7 Exam 70-680
$49.00$44.10
724 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.