InfoPath Dev

I'm trying to create a query form - basically, I want a user to be able to type in a customer account number, hit search, and other boxes will auto-poulate with company, address, phone, etc.

I've got all the customer information in a SharePoint list - can I connect to this for a query?  Everything I've been able to find suggests that a SharePoint list can't be set up as a primary data source, only a secondary, and that a query can't be run off a secondary data source...

Thanks for any advice!

That is correct Sharepoint lists cannot be queried.

Your choices are setup a secondary data conenction, which will load the whole list, then jsut filter a repeating section to only show the one they wanted or "queried". The drop back is performance of loading all records.

Or put the data in a database instead, you have SQL on the Sharepoint server, and then you can create a form based on the data and perform queries on it.

The very best is to database you enterprise solutions and then use web services like qdabra provides.  Then you can query and submit to multiple tables and query and submit to sharepoint.

Okay, but can I create a connection library in SharePoint containing the information from the list, and create a primary data source that way?

Sorry I missed this last week. SharePoint lists can be queried with our Web Service http://www.infopathdev.com/files/folders/dbxldownload/entry34123.aspx . Comes with a query builder tool that makes it easy to build custom queries. After installing the Web Service, just create a UDC connection in your connection library to the Web Service and add that to your form. Then, the data will come into your secondary data source and you can copy it to your primary data source. Contact us to see a demo. I believe we will be creating a video of this soon.