I have two different tables - "Clients" and "Potential Clients." Both tables
have 10 fields, with 5 of these field being the same within each table;
name, address, telephone, contact, email.

Now, when a potential client gets back to me to confirm they would like a
job doing, I would like to be able to click on a button on my "potential
client" form and this will in turn, copy the data from the potential client
table to the client table, that is to say, the data that they share (name,
address etc....). Likewise, once done, I would then like a continuation in
the code that will delete the whole entry in the potential client table, so
that there details only exist in one table.

Thanks