https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/12245.aspxWed, 30 Aug 2006 01:23:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12245Matt Faus0https://www.infopathdev.com:443/forums/thread/12245.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12245Hey Dean!<br /><br />Thanks for this info, I will have to try this out!https://www.infopathdev.com:443/forums/thread/12244.aspxTue, 18 Jul 2006 02:44:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12244Kalyan Gaddam0https://www.infopathdev.com:443/forums/thread/12244.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12244Hello,<br />Thanks for sharing the information.https://www.infopathdev.com:443/forums/thread/12113.aspxMon, 17 Jul 2006 20:41:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12113dlgross0https://www.infopathdev.com:443/forums/thread/12113.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12113I just learned that I can use SQL Server Query Analyzer to create/modify SQL statements and paste them into a Secondary Data Connection thereby bypassing the ADO Shape object syntax. This seams to be providing better performance and a much better design environment for the SQL statements. It also provides a flat data structure that is easier to navigate if you want to create Rules for populating other fields on a form.<br />HTH<br />Dean