 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / January 2008Import all related records
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 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 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 > [quoted text clipped - 16 lines] >> thanks >> Pete 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 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] >>>> thanks >>>> Pete 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. [quoted text clipped - 23 lines] >>>>> thanks >>>>> Pete 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. [quoted text clipped - 8 lines] >>>>> thanks >>>>> Pete |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.