https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17059.aspxThu, 27 Oct 2005 14:50:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17059vt_asparagus0https://www.infopathdev.com:443/forums/thread/17059.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17059Hi Parry,<br /><br />When you say "autofill" are you saying that you are running a query when form loads to pull customer address data? You can add other data connections to run other queries to pull order, order detail, etc. when the form is loaded.<br /><br />If this does not make sense, give us a litte more background on how you have set up your form.https://www.infopathdev.com:443/forums/thread/16751.aspxWed, 26 Oct 2005 09:55:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16751parrywang0https://www.infopathdev.com:443/forums/thread/16751.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16751I tried to autofill customer address infomation from SQL for a sales order or invoice form. I am able to autofill the customer info into a form with customer table only without code, however what I add order,order detail, customer, and item. I can't autofill the infomation any more. Please help.<br /><br />Thank You<br /><br />Parry Wang<br />Miracle Global Inc