-
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?
-
So far so good, plus the table for the order.
-
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?
-
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.
-
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules