Alastair, Yes indeed, TempView is perfectly sorted but the combo box shows the data entry order. Sounds like a reportable boobooâ
Claudine â ________________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair Burr Sent: Monday, December 20, 2004 9:39 AM To: RBG7-L Mailing List Subject: [RBG7-L] - DB Combo LookUp Box: view not sorted Could anyone confirm this behaviour: Create a temporary view containing an "order by" clause. Create a new form with a DB Combo Lookup Box based on the view. I expected the lookup data to be sorted in the same sequence as the view but it appears to be sorted in the same sequence as the data in the table. For my tests I took the Contact table in ConComp and created this view: create temp view TempView as select + CustID, ContFName, ContLName, ContPhone, ContInfo, ContPhoto + from Contact order by ContLName The Table and Data Fields were set to TempView and CustId; the Lookup Settings were set to TempView as the source, CustID as the key and ContLName as the values; but nothing else was changed Regards, Alastair. ---------------------------------- A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ----------------------------------
