I am currently developing an inventory database. The items usually are consigned to a shop and then it's either returned to the head office and it will be consigned again to another shop or it will be sold. Is there a way that I can transfer all the sold items to a new table without fearing that the others will stay on the movement table?