Combine Tables Access 2010
Posted on 2011-02-11
I have an Access 2010 database. There are 15 tables. Each table is named for the product. Each table has the following fields: Product Size and Product Cost. The issue is that many of the products have the same size (12x48). I need to create something so that one person can access and update all the prices easily from one area instead of opening up each table. I tried to do a form, but because the fields in each table are the same, it requires a relationship, but each product is NOT related. I am fine with recreating the database, just not sure what best method there is for this.