https://www.infopathdev.com:443/forums/142.aspxAre you exploring new features coming up in 2010? Share information and ask questions here!enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/99280.aspxThu, 25 Sep 2014 08:06:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:99280Miggi030https://www.infopathdev.com:443/forums/thread/99280.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=99280<p>Dear all</p><p>I am having a problem with a form that populates names from a SQL data source. The problem is the names in the list are sorted totally randomly, this would not be a problem if they were also not jumbled up every time&nbsp;the form is reloaded.</p><p>&nbsp;Please see the pictures below for clarity&nbsp;</p><p><img src="http://i.imgur.com/tWwDgM4.png" alt="" />&nbsp;</p><p>&nbsp;The names&nbsp;do match up with the surnames so I&nbsp;have that going for me. But the trouble is the&nbsp;drop down choices&nbsp;on the right are supposed to&nbsp;align with the names. They do remain in place but again the names change place.</p><p>&nbsp;What I have&nbsp;tried so far.</p><p>1. Sorting A-Z via surname in the Data connection</p><p>&nbsp;<img width="333" height="90" style="width:333px;height:90px;" src="http://i.imgur.com/0FkEsau.png" alt="" /></p><p>2. Changing the way InfoPath&nbsp;sends confirmation as an attachment&nbsp;rather than a live view.</p><p>&nbsp;</p><p>Any suggestions would be greatly appreciated.</p><p>Thanks&nbsp;</p>