move the deleted records to another table

[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

 

[Rick B]

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

 

[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.

 

[Rick B]

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.

 

[Tim Ferguson]

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.

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


Tim F