Automatic Cut & Pasting of Rows?

[Guest]

How do I make a macro or some other function that allows user to choose any
row from a database which is then automatically cut & pasted to another
pre-speficied table (which acts kinda like an archive)?

 

[Joseph Meehan]

How do I make a macro or some other function that allows user to
choose any row from a database which is then automatically cut &
pasted to another pre-speficied table (which acts kinda like an
archive)?

Are you sure you want to do this. Usually this kind of request is based
on poor table design.

For example, if you want to archive data, you generally add an binary
(yes no) filed called archive so the data all remains in the same table and
is just marked as archived and then hidden from non-archive uses.

 

[Guest]

I don't understand. How do you do this, exactly?

 

[Joseph Meehan]

I don't understand. How do you do this, exactly?

The exactly part depends on exactly what design you already have.

In general it means adding a binary (yes no) field. You can call it
Archived if you like. Then rather than moving the data out of the current
table to a new on, you just set the binary filed to yes. Then use filters
or queries to display just the archived or not archived data.