InfoPath Dev

Hi--

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.

I looked at filters and formulas, but am not quickly seeing a way to do this. Any ideas?


Hilary

Hi Hilary,
Welcome to the Forum!
There is tutorial by Greg for removing duplicate values from the dropdown.http://www.infopathdev.com/howto/tutorials/default.aspx?i=51dce616335a4ff6a78f2d289baf4651

But for the list to appear in alphabtic order you need to sort the dataconnection xml.

Agni
InfoPathDev India

Thanks--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. . .

Hilary

And just when I was about to give up, I got it. . . problem solved, thanks for your help!

Hilary