|
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] ---------------------------------- |
