Although I have a somewhat similar thread going on a topic like this (making a "Copy" of a record), there really is a very distinct difference so I wanted to post it seperatly so as not to confuse the issue.

Here's what I'd like to do: simply "move" a record from one database to another so that I would in affect be "archiving" the record. Then I would like to be able to a any point "move" it back to the the original db to return to an active status.

I would thingk this would be something nearly every user of a db would want to do. It seems like a logical step between adding and deleting records. Frequently, I want to in essence "hide" a record for a while so that it does not show up in searches, etc. But later I want it viewable again.

Any ideas how to go about this?

Thanks!

Liverpool