Duplicate + Move Rows

i have a client who is a real estate agent. He has residential homes, sold, and open houses. At any given time a home can be in 1, 2, or 3 databases. Easy to create functionality would be the ability to move a row row or duplicate a row into other databases

You can make a function that uses hooks to do that maybe. Or maybe put them all in one with different flags?