I am using SharePoint as the secondary data source. I am only able to return the first value in the SharePoint list that corresponds to the ID.
In SharePoint, I have SPField 1, SPField2. I can pull SPField 1 into InfoPath no problem. Now I want to populate another infoPath box with the value of SPField 2 when SPField 1 is ...