Subject Need help setting orderinglinks for LookupCombo
Author Marcin Bury
Hi List

I have a table

JOBS
JOB_ID integer
JOB_DATE date
JOB_MONTH integer
NUMBER integer
FULL_NUMBER computed by
(cast(NUMBER||'/'||MONTH(JOB_DATE)||'/'||YEAR(JOB_DATE) as VARCHAR(15))

Field MONTH is calculated as Year(JOB_DATE)*100+MONTH(JOB_DATE)
Field NUMBER is some kind of counter reseted every month
Saple data is
1,'01.11.2001',200111,1,1/11/2001

The problem is that I'd like to show the list of jobs in descending order
like this
12/12/2001
11/12/2001
..
50/11/2001
49/11/2001
and use IB_LookupCombo or IB_lookupEnh for selecting the job
Setting orderinglinks to FULL_NUMBER=JOB_MONTH DESC, NUMBER DESC works
perfect for displaying jobs but I have no possibilty to perfom any searching
(it obvious).

Is it possible at all to get any orderinglinks to combine the ordering and
searching in this case?

TIA
Marcin