Moving data between tables

[Chris]

*What I have*

I am currently building a mortgage database. I have completed the first
section - add enquiry (when a prospective client enquires about a mortgage)
which stores basic personal details, type of mortgage and employment status.
I also have a form which shows all the enquiries received.

*What I want*
When the prospective client becomes an acctual client more details have to
be collected (about 50 details). I would like to seperate the
enquiries/prospective clients and the acctual clients. So I would like to
move all the contents from the enquiry table to a the clients table for
individual clients that decide to join.

using Access 2002

Can anyone help?

 

[DS NTE]

You dont need to have two tables, and its considered bad programming to do
so....
Just add a YES/No field to your table, name it "Accepted" ? Show that in
your "enquiry-form" as a check-box, when the prospective client becomes an
actual client just check that box. Use a query to filter out all your
accepted clients in another form.

Does this make sense....?

kes