Results 1 to 2 of 2

Thread: History table

  1. #1
    Join Date
    Aug 2003
    Posts
    160

    Unanswered: History table

    Hi I have created One table form for Customer, one for order.

    If the order is complete I want to store these in seperate table called history table. After I send the data to history table, It should be only in history table not in the data base How Can I do this.

    Can Anyone help me!
    Vad

  2. #2
    Join Date
    Apr 2003
    Posts
    280

    Re: History table

    Originally posted by vad
    After I send the data to history table, It should be only in history table not in the data base How Can I do this.

    I don't understand this sentences. All tables is in a database. The only thing i can think of right now is APPEND it to the history table then DELETE it from the source of the specific table. Someone told that ACCESS wan't made to do alot of deletion, it would corrupt the database or something. Correct me if I'm wrong someone.

Posting Permissions

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