Ordering

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Darren Woodbrey (darrenwoodbrey_at_hpfairfield.com)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 15:07:23 -0500

Hi,
    I have a asp work order system with a sql backend. This includes a
schedule. The schedule is seperated by the "status" that the work order is
in. When the work order gets to "Backlog" status, it shows on the schedule.
I want to order all work orders in "Backlog" status by the order date field.
This is no problem. The only thing is that after the intial order, I want
the user to be able to put these work orders in any order they want. I have
an "order" column, that the user can change via a drop down placing the work
order in any order that they would like.

My issue is the initial order by date and then using a different column.
There will always be new work orders entering the "Backlog" status. Does
anyone have any ideas on this? Is this possible? Thanks!

Darren