Need advice on table design & VBA code

[Corta]

I have a Access 2007 database where I have a couple important tables.
One table is for my customers (tbl_Cust) and one table for people I am
marketing (tbl_Marketing). My application tracks the time I spend
with my customers and then I create an invoice, etc. That all works
just fine. I would like to be able to flag my marketing contacts and
convert them to customers when I sell them something. So, I was
thinking the design of my marketing table could be identical to the
Customers table, except I could have a checkbox type field indicating
that I have sold them something. Then I could place a button on the
form to select and copy a specific record (the one I am on inside my
form at the moment) to my Customers table. I would want to
automatically delete them from my marketing table after the
information has been copied over to the Customers table.

Can you help me with some of the basic VBA syntax that I will need
like selecting the record I am currently viewing, then copying it to
the other table. And, if you have any ideas on table design or a
better approach I would appreciate your thoughts.


Thanks,

Corta

 

[Pete]

Better idea, use one table and your check box. Create form based on query
that checks for true false on the check box and bingo, you have it. Can use
same form for all customers, haven't bought customers and have bought. Add
button to change query to is true or is false. Never duplicate data, wastes
space and slows down the fun. Pete D.

 

[Pieter Wijnen]

more importantly, makes "what if, whom etc" queries that much harder to
create & maintain

Pieter

 

[Pete]

Good point!
"Pieter Wijnen"

more importantly, makes "what if, whom etc" queries that much harder to
create & maintain

Pieter