https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/29573.aspxSat, 21 Jun 2008 04:42:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:29573Clay Fox0https://www.infopathdev.com:443/forums/thread/29573.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=29573<p>Hey George.</p> <p>This is the default behavior of a Database type form.&nbsp; They are limited. You can only query one group of tables and all children are returned by default.</p> <p>With webservices you can have much greater control and performance.</p>https://www.infopathdev.com:443/forums/thread/29486.aspxWed, 18 Jun 2008 22:38:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:29486Tome0https://www.infopathdev.com:443/forums/thread/29486.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=29486<p>Lately, I was noticing that my form was pulling ALOT of data across the line when opening a form. I opened SQL Profiler to see what was going on. I found that the form is pulling a single record from the main table but pulls all records from the related tables.&nbsp; The form only shows the related records so I don&#39;t understand why its querying for all of them.<br /></p><p>I created a new form really quick to see if it would happen and it was doing the same thing.</p><p>The main data connection consists of a main table and 4 releated tables.</p><p>Does this sound familiar to anyone? If so, does anyone have a solution? Could it be a SQL Server configuration issue, or is it an InfoPath form issue?<br /></p>