Alphabetise Drop Down Lists

Alphabetise Drop Down Lists

Post by QmVu » Sun, 26 Feb 2006 02:48:28


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
 
 
 

Alphabetise Drop Down Lists

Post by Uy5ZLk0uIF » Sun, 26 Feb 2006 03:04:28

Does the database table or query contain an ORDER BY clause?
---
S.Y.M. Wong-A-Ton

 
 
 

Alphabetise Drop Down Lists

Post by QmVu » Wed, 01 Mar 2006 19:49:27

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
 
 
 

Alphabetise Drop Down Lists

Post by Uy5ZLk0uIF » Wed, 01 Mar 2006 20:17:29

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.
---
S.Y.M. Wong-A-Ton