|
||||||
|
Merge Tables By Richard Rost ![]() ![]() Merge Tables From Many Sources Into One Database In this video, I will show you how to merge the customer tables from two different offices of the same company. They have been using their own copies of the same Access database for years, but now want to merge them together. How do you keep the records unique? Douglas from Ann Arbor, Michigan (a Platinum Member) asks: I built my company's database using your lessons over the past several years. Each of our three offices uses my Access database, but they all have their own local copy with the data only for that office. Now we want to merge them all together and move the data up to SQL Server Online so we're all working with the same information. How can we do that and keep our customers unique for each office? Should I have Customer1T, Customer2T, and Customer3T? How would that work with forms and reports? MembersMembers will learn how to handle the relationship issues that come up with merging multiple parent tables together. We'll need to pull some additional tricks out of the hat using Union Queries, Double Joins, and lots more. Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today! Pre-Requisites
Links
Recommended Course
|
Age | Subject | From | |
4 months | duplicated clients | Jhoan Romero | |
10 months | Merge Tables Videos | James Cox | |
10 months | Wow | Bert Harmsma | |
| |||