https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/7156.aspxWed, 13 Jul 2005 20:55:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7156Anonymous0https://www.infopathdev.com:443/forums/thread/7156.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7156And just when I was about to give up, I got it. . . problem solved, thanks for your help!<br /><br />Hilaryhttps://www.infopathdev.com:443/forums/thread/7155.aspxWed, 13 Jul 2005 20:53:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7155Anonymous0https://www.infopathdev.com:443/forums/thread/7155.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7155Thanks--I tried the tutorial--I am still having some trouble relating the example to the actual fields I am using, but I shall keep experimenting. . .<br /><br />Hilaryhttps://www.infopathdev.com:443/forums/thread/7154.aspxWed, 13 Jul 2005 17:06:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7154Agni Jonnalagadda0https://www.infopathdev.com:443/forums/thread/7154.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7154Hi Hilary,<br />Welcome to the Forum!<br />There is tutorial by Greg for removing duplicate values from the dropdown.<a target="_blank" href=http://www.infopathdev.com/howto/tutorials/default.aspx?i=51dce616335a4ff6a78f2d289baf4651>http://www.infopathdev.com/howto/tutorials/default.aspx?i=51dce616335a4ff6a78f2d289baf4651</a><br /><br />But for the list to appear in alphabtic order you need to sort the dataconnection xml.<br /><br />Agni<br />InfoPathDev Indiahttps://www.infopathdev.com:443/forums/thread/4777.aspxWed, 13 Jul 2005 16:32:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4777Anonymous0https://www.infopathdev.com:443/forums/thread/4777.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4777Hi--<br /><br />I am working with an InfoPath form that has a dropdown that will pull its items from a SharePoint list. This is a list of contacts which has more than one entry for a variety of cities and countries. I would like to have a dropdown for country that shows each country only once and in alphabetical order, even though in the list there are probably 20 entries for USA, 15 for Canada, 12 for Mexico and so forth. I would also like the countries to display in alphabetical order. <br /><br />I looked at filters and formulas, but am not quickly seeing a way to do this. Any ideas?<br /><br /><br />Hilary