Re: Query and compare a list

ErnestoM — Mon, 30 Nov 2009 15:13:32 GMT

InfoPath 2007 allows you to query Sharepoint and obtain the entire list. Once that data "lives" in your form as a secondary data source, you can filter it as needed.

If you wish to filter on the server (for better performance) you'll need to write your own web service, or purchase one such as Qdabra's. Video demo here.

Query and compare a list

Michael71 — Mon, 30 Nov 2009 14:22:53 GMT

I have 600 Social Security Numbers, Last Name, First Name, addresses, and thier childrens names in a SharePoint list. On a InfoPath form I want to be able to type a Social Security Number and a Last name. If both the Social Security Number and the Last name is in the list on the same row, I want the other information (address and thier children names) on that row to populate the form.

Data Connections

Re: Query and compare a list

Query and compare a list