Autofill based on selection in a drop down box and a "popup" form

I have an InfoPath form with the main view and I've created a second view that only has two fields.  One is a drop down and points to a SharePoint list for it's data source.  I pull two columns, the location and a person's name.  When they select the location, the text field to autofill with the person's name associated with that location.

Or actually, I should have the text field on the main form, do the autofill, that's where I really want it. Right?
Anyway, I think I'm missing something, I can't get the text field to autofill with the correct name.  
Thanks
Sherry
SherryDeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Clay FoxDirector of Business IntegrationCommented:
You need to use a filter.

Setup the second field to default to the employee name from the SP list. When selecting the field there will be a filter button in the lower left.

Add a filter where location field in the SPlist = the field the dropdown control is bound to.
The dropdown should be bound to a field in your main data source and then use the SP list location field as its external source for selections.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SherryDeveloperAuthor Commented:
Thanks, I knew it had to be that simple.  I wasn't filtering right.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
InfoPath

From novice to tech pro — start learning today.