Automatically move a record from one database to another
I'm making two databases, one for products that are marked 'for sale' and one for products that are 'sold'. I was wondering if there is a possibility to make a button that will automatically shoot a product from the 'for sale' database to the 'sold' database. Basically I just don't want the products that are sold to be in the same data set as the products that are still for sale.
If this isn't possible, what is the best way to achieve the same effect?
Thanks in advance,