Combo Selection / Filter

[Alex]

Acc97..

I have a database which records down-time on 8 machines, the selection
of reasons comes from a combo box. I have tried to be clever! and
limit the options relative to each machine within the SQL and
selecting the most reoccurring reasons on the top of the list. Sounds
good..

Problem...

I now have 8 lists which describe a generic reason in 8 different
ways!

What I would like If possible?

one list being used for all the machines, which when a particular
machine is selected the combo box puts those relevant data at the top
of the list( saves time hutting) with all the other list items being
placed further down but not excluding selection.

Is this possible? or is there another way of achieving this??

Thanks,
for any help
Alex..

[Pieter Linden]

Re: Combo Selection / Filter

Machine---<MachineDownTim eReason>----DownTimeReason
M MDTR DTR

you could do a count on something MDTR and group by MDTR.ReasonID and
DTR.Reason and then order by the count... If you do an outer join,
you could get the DTR's with no matching values.... they'd just be at
the bottom of the list.