Master Table for Import only

[Eric]

Hoping this will be easy. I have a database that I am importing Form Fields
into from a MS Word Template. That process is already being taking care of
from the user side, using the template. The user actually exports the form
to the Access DBase.

As the records come in, they go to what I call the (Master Table). This
table is large with many memo fields. I want to spread the data out to
several other tables with in the Database and build my queries, forms and
reports from those tables and not the Master. As a matter of fact, I would
like to redistribute the records from the Master to the other tables and then
delete the records in the Master.

All the Field names in the new tables are the same as the Master. Each
Record has an ID Number that is unique and is used as the common field for
all the tables.

I'm hoping to automate the record distribution on open or at least by macro
button.

Can anyone help with this idea and any solutions, simple is ok, but if not
VB Code will work too.

I am just learning VB Code, so please stay with me on this one.

Thanks

 

[Pete D.]

Read the help file about append, delete, update query. Once you build
queries to do what you want you can create a simple macro to run them all.

 

[Eric]

Pete thanks for advise, but are you saying that all I need to do is run an
append, update and than Delete query to accomplishe the moving of records
from the master table to the others.

Sounds easy, is there any VB code that would automate the process after the
queries are built.

Any other thought from others out there?

Thanks

 

[Eric]

Pete, Append and Delete queries, worked great.... thanks