Copy data from one table to next automatically

  • Thread starter Thread starter Neil Greenough
  • Start date Start date
N

Neil Greenough

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
 
Hello,
I suggest to use just one table 'Clients' with a Boolean field
'potentional'.
In queries, forms etc. you can filter on the field 'potentional' to get real
or potentional clients.

Otherwise you must write some DAO code that copies the record from one to
the other table and deletes the record afterwards.

good luck

Hans Kemper
 
Back
Top