I am developing an InfoPath template from a library. I would like for it to connect to a separate list in the same site and display data based on a selection from a drop down on the form.
The drop down field should contain all the unique identifiers from a SharePoint list. Then, when the user selects one, it populates a few of the other fields on the form with the data that is associated with that item.