database design

[Walmondo Kelly]

http://robertkelly-carrollia.com/dbrelationships.html

This size table should be coming off the inventory table I think.
How do I do it?

 

[Danny Lesandrini]

Delete the line from Sized to Sales and drag ProductCode from Inventory to ProductCode on Sizes table

 

[Duane Hookom]

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.