By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Combo Selection / Filter

P: n/a
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..
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Machine---<MachineDownTimeReason>----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.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.