Moving data between tables

  • Thread starter Thread starter Chris
  • Start date Start date
C

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?
 
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
 
Back
Top