Drop down list in a browser form

spegg — Thu, 24 Jun 2010 19:12:59 GMT

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

Controls