Hi, One for all you pro's out there! Try to get your heads round this one, The tables are:
Table 1 = Item
ItemCode (primary key)
Description
Format
Unit price
Stock Level
------------------
Table 4 = CustOrderItem
CustomerOrderNo (pk)(fk)
ItemCode(pk)(fk)
CustOrderQuantity...