Move a record from one table to another

[Guest]

When my user clicks on the remove record button in our database form, rather
than the record being deleted I want it to actually move to another table.
How would I would I set this up.

 

[Rick B]

Why not just "mark" the record as removed and leave it in the same table?
This is pretty common with terminateed employees or old records that may not
need to be used often. Instead of using a remove button, just add an
"inactive" field to the table and let the user check it.

All the queries that you use for your forms and reports could filter out
those records. If you do need them for something, then you could include
them.

Much safer than moving records around from table to table.

Rick B

 

[Ed]

I have database that starts with estimates then goes to proposals -
workorders - purchase orders. I use an append query to send data from one
table to the next. that way i retain the original data i started with while
moving the record to the next level of the sales line. My tables have
related tables so its a dual macro that starts with the main table then
appends the related tables in order. acts as one step to user.