AnsweredAssumed Answered

Moving Records

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

Title

Moving Records

Post

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, 

Outcomes