https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/26879.aspxFri, 29 Feb 2008 15:07:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:26879Clay Fox0https://www.infopathdev.com:443/forums/thread/26879.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=26879<p>Hi and welcome to Infopath and the forum.</p> <p>You can do this easily, however not with the standard database data connection.&nbsp; As you have seen it does not allow for dynmic queries.</p> <p>Web Services are the best practice as they give the most flexibility.&nbsp; There are ways to paste a query together in code but this can be tough to manage or not as efficient.</p> <p>Do you have access to a web server / sql server that you could install some web services?&nbsp; Then you could query and table you wanted to.</p>https://www.infopathdev.com:443/forums/thread/26874.aspxFri, 29 Feb 2008 13:53:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:26874denfer060https://www.infopathdev.com:443/forums/thread/26874.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=26874<p>I&#39;m quite new with Infopath.</p> <p>Is it possible to query a Database using a value selected in&nbsp;a DropDownList ?</p> <p>I have a first dropdown list that are filled with ProjectName list</p> <p>I want to fill a second dropdown (Task List) list according to the ProjectName selection.</p> <p>The problem is that ProjectName and Task List are not on the same&nbsp;server.</p> <p>I have a store procedure that take the ProjectName en entry and return the TaskList coresponding to it on the right server.</p> <p>I need either to connect to this store procedure or something like that</p> <p>Regards</p>