My main objective is to sort a datasource in my Drop down list.
As you all know, a browser infopath form will sort values in a drop down by their ID.
I have a list (Travel), the name column is a Lookup in another list (Directors).
My drop down is displaying the Travel column Name("Directors(name)")
My datasourse is an owss url.
The problem is, the drop down list is displaying the lookup values (ID and Value). i.e. 23;#BOM
can I substring the value before displaying? Remember this is a browser form.
Thank you