How Would You Structure This?

[eluser]obiron2[/eluser]
I'd have a table

Table:Queue

QueueID (autonumber)
QueueName

Table:QueueList

QueueID
QueuePosition (int)
ProductID (varchar)
StockLimit (int)

Primary: QueueID/QueuePosition
Unique: QueueID/ProductID

This way you can put a product into more than one queue and set different expiry limits on it.

To build your display product list, I would join to the Product table on ProductID and select where Product.AvailableStock >= StockLimit order by QueueList.QueuePosition

I would have thought your bigger problem would be the admin side. Moving database records up and down a manual preference is normally a pretty torrid affair unless you are going to use Ajax/javascript functionality to make it drag and drop.

obiron