View Single Post
  #9 (permalink)  
Old 03-04-10, 13:59
MarkATrombley MarkATrombley is offline
Registered User
 
Join Date: Jul 2009
Location: Michigan
Posts: 125
My thoughts:

Order (OrderID, Date, CustomerID)
OrderDetail (OrderDetailID, OrderID, ProductType [Box/Bucket], Qty)
BucketDetail (BucketDetailID, OrderDetailID, Material, etc)
BoxDetail (BoxDetailID, OrderDetailID, Material, etc)

ProductTypeMaterialOptions (ProductType [Box/Bucket], MaterialID) -- Lists valid materials for each product type.
Reply With Quote