InfoPath Dev

Thanks for the update Tom. I'll be interested to see how this functionality will work once released. We need something that enables us to build forms that query Sharepoint lists as easily as we can query an Access database. We need a solution that we can implement ourselves and not require special coding and updating.

Thanks, I had seen this before but didn't realize that it talked about not being able to use the GetListItems method directly. So it sounds like there's a long-winded way to get there, but I'm not sure how this will work (not sure what needs to be done) with existing lists. This example is specific to a form library but I want to query ...

Thanks again. I'll consider filtering the repeating table instead and once the lists get too large, then we'll have to do it "the right way". Since this topic is starting to veer off in a different direction, I decided to post a new thread in the Sharepoint Integration ...

After lots of research and direction from these forums, it seems that the best solution to query data in Sharepoint lists is to use a web service. I'm quite new to all this and I'm after a querying solution without coding if at all possible. If that's not realistic, please let me know as it would save me from going in circles, and ...

Just as I begin to warm up to data connections, I get confused once again :( When I started playing around with Infopath for the first time, I did so by creating a form to query an Access database. The database was my main connection and it showed query fields and data fields. So I created some combo boxes bound to these query fields and the data ...

Thanks a lot for that link. Now I have enough reading to keep me busy this evening :)

So the main data connection is actually queried when you click on the Query button only? I guess that makes sense when it comes to launching the form or it could take too long to just bring it up on screen. Is there a general rule as to what the purpose of the Main Connection is as compared to the Secondary? Thanks again for your help.

I'm creating a form to query an Access Database and I'm having trouble understanding the data connections. I cannot seem to be able to do anything with the "Main Connection". Let me explain. I simply want to create a drop-down control to display choices and then submit the query. So I started from a template designed for this ...

I left the value empty (did not put the double quotation marks) and it's working for me. I'm using a drop-down list box.

Ignore me...your solution works perfectly. It was a lot simpler than I thought! Thanks a lot.