append query using one to many database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an existing relational database with a "one to many" relationship
using two tables and would like to create a second database with the same
exact structure and append to it some records from the original database.

Is that possible using an append query?
 
Yes, it is.
Or you just copy the database, create a query to identify records not
wanted, and delete those. Do the many side first, then the one side.

Regards,
Andreas
 
I have an existing relational database with a "one to many" relationship
using two tables and would like to create a second database with the same
exact structure and append to it some records from the original database.

Is that possible using an append query?
Click to expand...

An Append query would be one piece of the process. You can't create a
new Database (mdb file) with a query; I'd suggest just using the
Access user interface to create it, and then using File... Get
External Data... Import to import the tables. Choose the option to
import *design mode only* so you get empty tables.

Then use File... Get External Data... Link to link to the old tables
from the new database. You can then run two Append queries in
succession, parent table first, then child table; use whatever
criteria you want to select which records you want included.

John W. Vinson[MVP]
 
Back
Top