• I would keep your order structure and probably create a SCHEDULED_ORDER table and have a job add the order to the table or the application pull in the defaults and allow for changes. This way you are separating an actual order from a possible one.

    Cheers
    http://twitter.com/widba
    http://widba.blogspot.com/