Make a Field Return Data based on another field.

[Thames]

Hello all,

I'm very green with InfoPath and I'm trying to figure out the following, so
thank you in advance for the assistance.

My question is the following,

If would like to make a drop down box that will allow for the selection of a
Vendor and when i do this to have a box undernath return a display of the
Vendors name automatically based on which one I select, how do I do this?

(i want to do a box for each of the vendors infomation first name, last
name, address, etc...)

I nabbed the Northwind database from the Access Templates on Office online
to test out a couple other things with, if that can be used for explainning
this. (And the data connection, there is a SharePoint site I'll be pulling
the information from but to my understanding the SharePoint and Access work
the same for what I'm trying to do.)

 

[Brianmc]

In the your main field you want to lookup add a drop down list and then
select in the properties "lookup the data from an external source" and find
the field you want. This creates a data connection to the file if it's not
in the sharepoint site.

For the corresponding lookup fields like Address fields you add a regular
text field and in the properties select the fx button, insert field, change
the "data source" at the top to the table of the external data (or not if you
are looking up on the sharepoint site) and find the field e.g. "address" you
want to bring back. Then you before you close out you select "Filter" and
select where the lookup field you are comparing equals the field on the
external site. eg. lastname (eg. on the sharepoint) = lastname(e.g. in the
access db) and that should pull it back