https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/66191.aspxThu, 28 Apr 2011 13:30:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:66191mgknebel0https://www.infopathdev.com:443/forums/thread/66191.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=66191<p>Set up the form to one table in a database and everything is working great, except that when I query the table it returns the information in whatever order it feels like instead of the primary key of the table in Access which is a text field (ex&#39;s. &quot;11L-001&quot; and &quot;11L-002&quot;).&nbsp; I have tried custom rules in the query and editing the SQL in the Data Connection but I do not know how to write code.&nbsp; Any help is appreciated.</p>