I have an Info Path form which contains a drop down list attached to a Data connection. The data is coming from a SharePoint list with well over 20,000 records. To combat the size of this list we are querying/filtering the list by country, reducing the records count.
I know that the max records returning for any given country is 800 yet i still get an error when trying to display the drop down in the info path form.
Is there any way round it?