Results 1 to 2 of 2
  1. #1
    aceoftrades is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2012

    Setting up relational database

    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.


  2. #2
    bigroo's Avatar
    bigroo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jan 2012
    Austin, Texas
    Hi aceoftrades,

    Welcome to this great forum!!

    From what you describe in your note, the 40plus tables should all be linked to the ProjectT table and only the this table will be linked to the CustomerT table only for projects for that Customer.

    What you could do is combine all your products into one table, then setup tables for Color, finishing type etc. This would make it easier to handle, this would be my approach, anyone else with more experience, please chime in.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Need to hire out relational database design
    By janakybrent in forum Access
    Replies: 5
    Last Post: 02-19-2016, 05:11 AM
  2. Relational Database Design Questions
    By mribnik in forum Database Design
    Replies: 40
    Last Post: 08-09-2011, 02:57 PM
  3. Relational database for mice breeding
    By shiphtfour in forum Database Design
    Replies: 19
    Last Post: 12-16-2010, 10:01 PM
  4. Relational Database/query help
    By Champin4 in forum Queries
    Replies: 7
    Last Post: 07-14-2010, 08:49 PM
  5. Setting up new database
    By mduplantis in forum Database Design
    Replies: 1
    Last Post: 06-23-2010, 11:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums