How would you set up this database?

[DuWayne]

I need some guideance on setting up a new database. Right now I have 50+ tables in my database and growing every day, with 59 fields in each table. Each one of the tables have the same 59 field names and carry bill of materials for each table. The data in each is different. Some carry more materials than others. Each table has a different name of the product we build. I want to combine all the tables into one and query the data I need. Any ideas on how I should set up the new one. Please be specific on your answers. Light in knowledge when it comes to access.


Thanks

[orange]

50+ tables and growing every day suggests serious design issues.
Do you have a data model? Have you gone through the process of Normalizing your data and building an Entity Relationship diagram?

You need to get your tables designed before getting too deep into the Access "technical" side.

I posted a list of free videos on Normalization and E-R diagrams in
the post at
https://www.accessforums.net/forms/ii...orm-21571.html