Hello and thanks for looking at my issue,
I have an InfoPath 2010 form which retrieves data from 3 lists on SharePoint 2010.
The lists are Projects, Company & EME with the Company column being common to all 3.
What I would like to do is for every occurrence of a company (selected from a drop down lookup in the Company list) in the Projects or EME list is to populate the form with the information from each row.
I.e.
Company list
Company Umbrella
abc Alpha beta
def Delta echo
ghi Golf hotel
Projects list
Company Date attended Manager
abc 23/02/2016 Dave
def 26/02/2016 Mike
abc 16/02/2016 Jim
EME list
Company Compliant Date issued
abc Fully 23/02/2015
ghi No 29/09/2015
InfoPath result
Company drop down
abc
Date attended Manager Compliant Date issued
23/02/2016 Dave Fully 23/02/2015
16/02/2016 Jim Fully 23/02/2015
Hope this makes sense.
Lee