Table Set up

[JohnGio56]

Hey guys,
So I'm having a little trouble setting up my tables. Here's a brief background:
I got a huge excel file in which there was multiple tables combined into one. My boss wanted me to break the sheet down logically all with the same unique identifier. Then I also need to import the entire table into the database. What I need to do is have the forms not only update the small tables but also the big one. Updating the small tables was easy but I'm not sure how I can have the form also update the same fields in the big table too. If this makes any sense I would really appreciate the help bc it's ticking me off. Thanks guys!

 

[PureCoffee]

Hi,
To Clarify:
1) one large excel sheet containing ALL tables which means ALL field names from ALL tables match each other?

2) Not sure what you mean break it down. Do you want to normalize the data?

/Purecoffee

 

[PureCoffee]

I think what you want is to do a query that selects all records from the smaller tables to create a new "all together" table which in essence would replace the old table with the new data from the smaller tables...
?

 

[JohnGio56]

Essentially what I want to do is not only update the normalized tables but also the large table. If I normalized the database will I still be able to run queries for reports?