Results 1 to 6 of 6
  1. #1
    just_lionel is offline Novice
    Windows Vista Access 2003
    Join Date
    Jun 2009
    Posts
    3

    It's been a while...


    Okay its been a while since I did any database work so I need some guidance...

    I am working on a database that will allow order entry. Depnding on the Dimension they select, it then will allow them to select the product grade then allow them to select a valid category and finally..shipping options.

    If I am thinking correctly, I will need four tables correct? One for Dimensions, one for product grades, product categories, and one for shipping options.

    Am I thinking correctly?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So far so good, plus the table for the order.

  3. #3
    just_lionel is offline Novice
    Windows Vista Access 2003
    Join Date
    Jun 2009
    Posts
    3
    How would the relationships be setup? That is where I am sticking on I am guessing the Dimensions would be the main table because that feeds from that?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I would suggest that each table have an AutoNumber PrimaryKey (PK) and that this key is what is inserted into the "Order" table as a ForeignKey (FK). Then all of the tables will have a relationship with the "Order" table through their FK field.

  5. #5
    just_lionel is offline Novice
    Windows Vista Access 2003
    Join Date
    Jun 2009
    Posts
    3
    So how would it work when the select a dimension to pull only the valid product grades for that dimension (55 dimensions total and 12 grades, not all dimensions have the same grades). I am trying to keep out human error

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

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

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