It's been a while...

[just_lionel]

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?

[RuralGuy]

So far so good, plus the table for the order.

[just_lionel]

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?

[RuralGuy]

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.

[just_lionel]

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

[RuralGuy]

You will need to Cascade your ComboBoxes.
http://www.fontstuff.com/access/acctut10.htm
http://www.baldyweb.com/CascadingCombo.htm