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/53910.aspxTue, 20 Apr 2010 17:25:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53910Visfire0https://www.infopathdev.com:443/forums/thread/53910.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=53910<p>&nbsp;Never mind! I figured this out on the modify table properties from the data connections menu - thanks anyways folks! <br /></p>https://www.infopathdev.com:443/forums/thread/53897.aspxTue, 20 Apr 2010 13:42:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53897Visfire0https://www.infopathdev.com:443/forums/thread/53897.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=53897<p>&nbsp;Hello, I&#39;m relatively new to infopath and created a relatively complex form that pulls back hundreds of fields from an access database in a repeating section.. I have a button on there to switch view to a submit view where the user can input a new record - which works great. After a new record is created, the form refreshes back to the main record list and displays all entries .</p><p>&nbsp;</p><p> Only issue is that after a new record is created, it seems to be placed out of order in the repeating section. I&#39;ve got the database itself arranged according to an &quot;item number&quot; that I randomly assign to each record. I would have assumed the new record I created would appear at the bottom of the repeating list&nbsp; but instead it appears as the first new record. Presently, if you look at the pattern of the item # on the returned records it goes ..&nbsp; 143 142&nbsp;&nbsp; ..100 101 102 103 104...&nbsp;&nbsp;&nbsp; so basically i want it to look like&nbsp; 100 101 102 103&nbsp; .... 142 143.&nbsp;&nbsp;&nbsp; How do I get this thing to sort the fields? </p><p>&nbsp;</p><p>Thanks!! <br /></p>