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,