database design

  • Thread starter Thread starter Walmondo Kelly
  • Start date Start date
Delete the line from Sized to Sales and drag ProductCode from Inventory to ProductCode on Sizes table
 
It isn't clear how your tables all related.

I would consider creating a primary key field in the sizes table named
[ProdSize]. This would create a unique combination of product and size. The
Sizes table would be linked to the Inventory table. The Sales table would
then need to include the ProdSize field value as a foreign key to the Sizes
table. You could then remove the ProductCode and Size fields from the Sales
table.

Width is not a good name for a field since it is a property of reports,
forms, controls, etc.
 
Back
Top