Hi All,
So I have this infopath form i created that pulls data from an access DB when you query a ZIP code. As of right now a query takes less than 5 sec to search over 40K records.
I would like to have everything setup the same way but have the data source now be a SharePoint list. I have uploaded the list to SharePoint and connected the data sources. Everything seems to be setup fine but when i try and query something i get hit with the following message:
"The Query returned large amounts of data and rendering your form may take some time. Do you want to continue?"
I have no idea why its saying its returning large amounts of data. It should only be querying 1 ZIP code and returning that row. I lowered the amount of records it needs to query from over 40K to under 2K and it still says the same message so that's not the problem.
Anyone have any ideas for me.
Thanks in advance.