I have two tables: A Customer table and a Prospects table, which has several fields that I don't want in the Customer table. When a prospect become a customer, I want to move the prospect's name into the Customer table via a form. The problem is that the Combo Box pulling from the Prospect table overwrites customer names in the Customer Table. Is it possible to add names from the Prospects table to existing Customers in the Customer Table using a Combo Box. Or do I need another tool? Or is there a way to merge the names from the Prospects table into the Customer Table. This one has me really stumped.