Import all related records

[Pete via AccessMonster.com]

I have a database with hundreds of customers (cusomer id) with many related
tables.

I have a blank database with the same structure.

How can I import a specific customer id and all of that customer's
associated records in the other related tables?

I basically need to slowly add some of the customers in my new database for
others to use.

thanks
Pete

 

[Jeff Boyce]

Pete

I would probably approach this by:
* opening the new "empty" db
* linking to the tables that hold data (the other db)
* creating queries that grab the customers (and more queries that grab
the "related" data)
* converting each query to an append query, appending the data from the
old to the new db

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[jptpjs via AccessMonster.com]

Thanks Jeff,

I will give it a try.
In the append query I would specify which customer id I needed to append?

It should would be nice if there was a feature to grab the specific customer
and all the other records just came with it. Sort of like a drag and drop.

Pete

I would probably approach this by:
* opening the new "empty" db
* linking to the tables that hold data (the other db)
* creating queries that grab the customers (and more queries that grab
the "related" data)
* converting each query to an append query, appending the data from the
old to the new db

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a database with hundreds of customers (cusomer id) with many related
tables.

[quoted text clipped - 10 lines]

thanks
Pete

 

[Jeff Boyce]

I don't know enough about your data to tell you how to select your
customers.

Is there something about the customer (?lastname, ?date added, ...) that you
could use in your query to retrieve only the customers you want? Then base
your remaining queries on only those that you've moved over into your new
db.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks Jeff,

I will give it a try.
In the append query I would specify which customer id I needed to append?

It should would be nice if there was a feature to grab the specific
customer
and all the other records just came with it. Sort of like a drag and
drop.

Pete

I would probably approach this by:
* opening the new "empty" db
* linking to the tables that hold data (the other db)
* creating queries that grab the customers (and more queries that grab
the "related" data)
* converting each query to an append query, appending the data from the
old to the new db

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a database with hundreds of customers (cusomer id) with many
related
tables.

[quoted text clipped - 10 lines]

thanks
Pete

 

[jptpjs via AccessMonster.com]

Each customer has a key field Customer ID.
I have relationships to most of my other tables with this id.

I am providing information for a user in which I would like a seperate
database and add customer information as needed.
In other words I do not want him to get information on all customers.

I don't know enough about your data to tell you how to select your
customers.

Is there something about the customer (?lastname, ?date added, ...) that you
could use in your query to retrieve only the customers you want? Then base
your remaining queries on only those that you've moved over into your new
db.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks Jeff,

[quoted text clipped - 27 lines]

 

[Jeff Boyce]

I believe I understand the need to put a limited number of customers in a
new database (although, based on the new information you just provided, you
might not need to!).

My question was about how you know WHICH customers to move over?

(By the way, if your concern is that you don't want your user to see, say,
any customer whose last name starts with a "W", you can build a query to
exclude those and use that query as the data source for a form you show your
user. That way, you don't have to move anything!)

Regards

Jeff Boyce
Microsoft Office/Access MVP

Each customer has a key field Customer ID.
I have relationships to most of my other tables with this id.

I am providing information for a user in which I would like a seperate
database and add customer information as needed.
In other words I do not want him to get information on all customers.

I don't know enough about your data to tell you how to select your
customers.

Is there something about the customer (?lastname, ?date added, ...) that
you
could use in your query to retrieve only the customers you want? Then
base
your remaining queries on only those that you've moved over into your new
db.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks Jeff,

[quoted text clipped - 27 lines]

thanks
Pete

 

[jptpjs via AccessMonster.com]

Jeff,

I think you found a better way!
Just give him the entire database and modify his front end to display
customer id's as needed.
Simple is always better.
Thanks

Each customer has a key field Customer ID.
I have relationships to most of my other tables with this id.

I am providing information for a user in which I would like a seperate
database and add customer information as needed.
In other words I do not want him to get information on all customers.

I don't know enough about your data to tell you how to select your
customers.

[quoted text clipped - 14 lines]