https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/29576.aspxSat, 21 Jun 2008 04:50:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:29576Clay Fox0https://www.infopathdev.com:443/forums/thread/29576.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=29576<p>Web Services would allow you to dynamically query mutiple tables as you describe. Check out the Web Service fgrom Qdabra.</p> <p>For the first item you may want to use a repeating table to create the tree view. Use conditional formatting to hide and reveal based on button selections.</p>https://www.infopathdev.com:443/forums/thread/29478.aspxWed, 18 Jun 2008 18:13:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:29478genecox0https://www.infopathdev.com:443/forums/thread/29478.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=29478<p>Trying to figure out the best approach:</p> <p>A. I have a problem trying to figure out the best design approach. The form has a Multi Select List Box that list a single column-(Column A) from Table A that has a hundred or so rows. I would like to show the remaining SQL corresponding form columns when one or more checked items are selected from the Multi Select List Box - and - clear them when they are un-selected. Do I create a custom form definition (.xsf) file, etc?</p> <p>B. I have multiple tables with the same columns referenced, using the same conditions above. I don&#39;t think InfoPath supports dynamic SQL - yet. In reality the only thing that is different is the table referenced in data connection. Do I use multiple secondary data connections, code logic, etc.<br /></p>