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/51193.aspxSat, 30 Jan 2010 13:07:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:51193Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/51193.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=51193<p>I think if you use the method outlined <a href="http://sharepointkb.wordpress.com/2009/01/15/retrieve-any-fields-for-infopath-from-another-sharepoint-list/">here</a> to get your data (creating an XML file connection and leveraging owssvr.dll), you can specify the view.</p>https://www.infopathdev.com:443/forums/thread/50979.aspxMon, 25 Jan 2010 16:38:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:50979eg100130https://www.infopathdev.com:443/forums/thread/50979.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=50979<p>I have two dropdown fields in my infopath form which lookup to a sharepoint list. I would like the first field lookup the list by company order while aonther field should lookup the list by ticker code. I created two views (one is sorted&nbsp;by company and one is sorted by ticker) in the sharepoint list. However, when I created data connection in infopath, I only can&nbsp;link to the sharepoint list, not to a view. So I cannot have different sort for each field. Please advice if there is any solution for my problem. Thank you.</p>