I'm new to Access and trying to setup a database for my Kitchen & Bath Remodeling Company while keeping my sanity. Currently I have a CustomerT, ProjectT (set up the same as typical Orders table), and many tables with products (ToiletT, VanityT, ShowerDoorT, etc). The reason I set it up this way was because many of the fields will be different for each catagory (ToiletsT will have Shape and Color while ShowerDoor will have Glass and Finish and so on.). I can't figure out a way to relate the 40+ product tables to the CustomerT and ProjectT tables. Should I just have one product table and then have a description table for each product as well? Not sure how to do that if that's the right way...Any help before I pull the rest of my hair out would be much appreciated.
Joe