move the deleted records to another table

  • Thread starter Thread starter sheela
  • Start date Start date
S

sheela

Hi,

My apologies if i am posting this question in a wrong
place. If so please advice me.
I have two table. First one is main table. If any record
is deleted from this table using a form, the record will
be moved to the second table. So that we can keep track of
all the deleted records.
If somebody directly delete the records on the table (
with out using a form), this won't work. How do we move
the deleted records from a table to another table, before
they get deleted.
Thanks for any hints.
Sheela
 
Why move the records? Just add an inactive date or checkbox. Instead of
moving them, simply mark them as inactive. Then, don't include any inactive
items in your queries, forms, and reports.

If you use a date, you can run delete queries when the records are so old
that you really want to delete them.

Rick B


Hi,

My apologies if i am posting this question in a wrong
place. If so please advice me.
I have two table. First one is main table. If any record
is deleted from this table using a form, the record will
be moved to the second table. So that we can keep track of
all the deleted records.
If somebody directly delete the records on the table (
with out using a form), this won't work. How do we move
the deleted records from a table to another table, before
they get deleted.
Thanks for any hints.
Sheela
 
There is an unique index associated with each record. Each
record is a plca holder for a sample. We can store one
sample only in a position. If the records are not deleted
from the table we can't store a new sample in the same
position.
sheela.
 
Look at the post in this group called, "Deceased People". It is asking
basically the same question as you and has several responses.

Rick B


There is an unique index associated with each record. Each
record is a plca holder for a sample. We can store one
sample only in a position. If the records are not deleted
from the table we can't store a new sample in the same
position.
sheela.
 
There is an unique index associated with each record. Each
record is a plca holder for a sample. We can store one
sample only in a position. If the records are not deleted
from the table we can't store a new sample in the same
position.
Click to expand...

sounds like a pretty standard one-to-many to me...


Tim F
 
Back
Top