InfoPath Dev

Hi Hilay

I'm trying to auto populate a "review" list with 3-4 fields of contacts info that are already stored in another contacts list.

The contacts list is quite large, about 2K records at the moment so I put in a button to query data from that list.
Do I simply put the function on each of the contact fields (Name, Email, Phone) to the contact list (secondary list) and then filter where my customer reference numbers match, or is there another step needed as it's not populating after button click

Or is there a simpler way to do this?!
I'm also getting the amount of data returned by data connection has exceeded the limit, so I need to get onto the admins about increasing I guess, or do I if there is a more efficient way to complete the same goal?

Thanks as always

 Do you have the customer reference number prior to querying? If you do, and if the customer reference number is in the contacts list, you could use query fields to restrict the amount of data returned. https://wonderlaura.com/2011/08/01/infopath-query-specific-sharepoint-list-data/

Hi Hilary
Yes I have it in both lists so will check this out
Thanks!