 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / February 2006Alphabetise Drop Down Lists
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 Does the database table or query contain an ORDER BY clause? --- S.Y.M. Wong-A-Ton > Hi. > [quoted text clipped - 4 lines] > > Thanks 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 > Does the database table or query contain an ORDER BY clause? > --- [quoted text clipped - 8 lines] > > > > Thanks 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 > 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? [quoted text clipped - 13 lines] > > > > > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.