Here is my problem:
i have three tables, each containing stock for a music shop (one containing the stock of records, one containing the stock of CDs, and one containing the stock of paper items). I also have a 'Orders' table. When a new order comes in, i enter it into the Orders table using a...