Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011
    Posts
    83

    Unanswered: Delete / Archive Records

    Hi All,

    I have a [tblSalesOrders]. The basic fields are:

    Customer
    OrderNumber
    Qty
    Description

    I want to be able to delete an order from a customer but then archive it rather than lose it. So, I have set a new customer up as ARCHIVE. I want my user to be able to select the order number and then have a command button to click. Once this is clicked, the Customer field will change to ARCHIVE.

    Does this make sense? if so, what code would I put behind the command button?

    Thanks
    Simon

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    why not simply define a column in the customer table called say IsArchived or IsActive, as a boolean value and if it is flagged as archive, or not flagged as active then no new sales accepted on the account
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2011
    Posts
    83
    Now why didn't I think of that? That will work fine. Tyvm.

Posting Permissions

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