I hope someone can assist me with the following question: I have a table called _rtblProspect (this is where I enter in prospective customers with a whole lot of user defined fields for additional information). My next table is Client (this is where all my customer information is stored). In the program that I am running, when I convert from a prospective customer to a customer, it does not pull through all the user defined information. Also, once I click on OK and commit, then the prospective customer is no longer in the _rtblProspect table. Is there some sort of stored procedure or trigger that I can setup that when I click on OK, it snapshots that prospective customer and populates the user defined fields in the Client table? Thanks in advance for the assistance.