Urgent: Secondary Data Source has limit of 100 records

[skwest]

I've got a field on an InfoPath form that is validating against a Sharepoint
List. It is only validating against the first 100 list items. Is there a
way to increase (or remove) this limit??

 

[Brian Teutsch [MSFT]]

Yes, this is a known issue with SharePoint lists. You can work around it by
setting the SharePoint list to display as many items as needed, and I've
been told you also have to set an option to limit this amount (sorry,
haven't done it step-by-step myself).

Brian

 

[Matthew Blain \(Serriform\)]

The default InfoPath adapter only returns whatever shows up in the default
view on your sharepoint site, including all filtering and limit options. Go
into the sharepoint view settings to change what you want to display.

--Matthew Blain
http://tips.serriform.com/
http://www.microsoft.com/mspress/books/7128.asp -- includes a chapter on
Sharepoint and InfoPath integration issues.