I have a browser enalbed form with dropdown list box control bound to a secondary data connection to a sharepoint list. I have two custom columns in the sharepoint list namely Value and Key. The dropdown list box control is bound to a secondary data connection in such a way that the Value and Description properties are bound to Value field of secondary data connection.
Now I need the drop down to shows all values sorted in alphabetical order. By default, it is sorting by ID column of sharepoint list. When I am debugging the form in VSTA it shows the items sorted, but, once i publish the form it doesnt so that.
Please help me out in resolving this issue.
Thnx in advance