Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    7

    Red face Unanswered: Archiving finished orders

    Hey,
    As the title suggest I want to make it so when a order gets finished it gets moved from the table current orders to old orders. Does anyone know how I would do this.
    Thanks.

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    You can copy the data to another set of tables then delete the data from the current orders table, but that is extra work that could easily be handled with a status field. When completed, set the status to either completed or archive then all of your queries that look at current orders just have to have a criterion that states where status <> "completed"

  3. #3
    Join Date
    Apr 2004
    Posts
    7
    Yeah I know what you mean. I already have a field Job Finished ( YES/NO) in current jobs. Just wanted to know if it was possible to move the row across when the job finished box was ticket.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •