I don't know. A sure way of having this to work is for Laserfiche to add a sort feature for each look up. ORDER BY clause in View generally gets ignored by SQL Server. I'll wait for Laserfiche Developer response to see if any changes are coming on the new version of Forms that is coming out soon.

Forms 9.1 will sort the look up result in alphabetic order from database if the look up is populating one field. If look up populates two or more fields, entries will be sorted by the first populated field. 

SQL does not guarantee the order of results without an ORDER BY clause and like, Mohammad noted, it ignored ORDER BY in view definitions. Forms does not currently allow you to specify custom queries and we currently don't have plans to allow picking which columns to order the results on. However, Forms 9.1 will allow you to use stored procedures for lookup, so you will be able to get sorted results that way.

Miruna,

Then just curious...why is it that my list is sorted properly in SQL, but does not show up that way in Forms?  That's why I'm struggling...I have two columns in SQL with lists....one being County the other Municipality.  When I chose a County, the Municipalities for that county are listed alphabetically, however, the County list is not in Forms, but it is in SQL.

Kenneth,

Even as I run the SQL Query?  I'm not using any external tools, I'm running a simple query to display the information in the table...and when it's displayed, it's displays everything alphabetically by County?  Not trying to beat a dead horse here...but you said you had the same issue and were able to fix it by using a view...then why doesn't that work for me??

Let me ask you this...do you think it would have anything to do with the fact I have the Counties listed more than once?  Example:  I have Adams County listed 42 times because there are42 municipalties

So with that being said...I would expect when I click on the County list in Forms that it would display Adams County 42 times...but it's only there once?  Also, as a workaround...is there a way I can just put the Counties in a Drop Down List in Forms...then perform the lookup for the List of Municipalties off that Field (similar to how RealTime lookup works)??   In other words...I chose Adams County from the Forms List (not a SQL table), and based upon the County I select, the list in Municipalties is pulled from the SQL Table?

This was started in 2013. I have SMS v 19

Is there a hotfix or has anything changed in LF to assist with this dropdown listing ASC ORDER? 

Mohamad's link "Apply the following hotfix for SQL Server 2008:" did not work for me.