Alphabetise Drop Down Lists

[Ben]

Hi.

I am creating an Infopath form to enter travel information for staff in
relation to case work. I have created a drop down list which pulls the data
in from the relevant database i.e. case number and case name, but the list
seems to be random. How do I alphabetise the list?

Thanks

 

[S.Y.M. Wong-A-Ton]

Does the database table or query contain an ORDER BY clause?

 

[Ben]

Yes, it has the order bu command in the table properties. Is there a command
in Infopath I can use, or should this be working?

Thanks

 

[S.Y.M. Wong-A-Ton]

Are you sure you checked if it has an ORDER BY clause by going to "Tools >
Data Connections...", [Modify...] button, [Edit SQL...] button? If you did
and it has, then it should be sorting the items. Perhaps it is ordering by ID
instead of NAME?

To my knowledge, there is no sorting command in InfoPath. You would have to
do it either through code or with XSLT.