Idea--Button select overwrites tables

[Uvuriel03]

I've got several different inventories broken down into several tables for normalization reasons. I was working on making a separate database for each--just copying all the queries, forms, reports, etc... and then importing the data for that customer from its original excel file. The thing is, each table has exactly the same layout, just different actual information.

So here's my idea.

I've created a splash form displaying a button for each customer at start-up. Now, would it be possible to, upon clicking on a customer's button, somehow have the data for that particular customer replace the existing data in the tables?

I was thinking that I could have a separate back-end database for each customer, and the OnClick of each customer would somehow link said tables or something along those lines.

The thing is, I have NO idea how this could be done. I've tried a few things here and there, but all in all, I am lost.

Thanks so much!

 

[boblarson]

Actually, unless there is an absolutely good business reason to keep separate customer tables, breaking them up that way is actually going against normalization rules. You would normally keep ALL data together in the same database and not having separate tables for each customer.

 

[Uvuriel03]

Well, it would be possible for me to put all of the data into one table, but I think my boss would be a little wary of doing so (he doesn't really understand normalization--he freaked out when I told him I'd split the original excel file up into several tables for the Access Database version).

So hypothetically, I have all of my data together in each normalized table. How would I filter this data from one customer to the next upon clicking? My worry is this--in a few of my forms, there are search functions that have a "Clear Filter" button. I'm worried that this would clear any default "By Customer" filter, if that's how it would work. I think I explained that right. I wouldn't want a user to accidentally edit the wrong customer's product information.

Thanks!

 

[boblarson]

CustomerID would be the way to identify a customer and be able to select your data. Perhaps these would be a better thing to read:
http://www.accessmvp.com/strive4peace/Access_Basics_Crystal_080113_Chapter_03.pdf
http://www.accessmvp.com/strive4peace/Access_Basics_Crystal_080113_Chapter_04.pdf