AnsweredAssumed Answered

Moving Records

Question asked by kennyferg on Aug 4, 2009
Latest reply on Aug 5, 2009 by ninja


Moving Records


Hoping someone can help me please. 


I have two tables, one containing customers and one containing prospects. I want to be able to turn a 'prospect' into a 'customer' by clicking a button.


I have created a relationship between the two tables allowing the creation of records on the customers side, but I don't know how to copy the records from the 'prospects' table into the 'customers' table. Ideally I would 'move' the record from being in the prospect table to the customer table.


I want to have the tables stored as separate tables as the customers table may contain 50-100 customers whereas the prospects table contains over 15,000 prospects.


Seems like this should be straightforward - fingers crossed.


Thanks in advance,