Database Design Question

    I am trying to design a Sales Order Processing section to a database and I am stuck. A customer can place multiple orders for varying quantities of the same item. e.g.

Order # 1001 Quantity = 1.
Order #1002 Quantity = 2.
Order #1003 Quantity = 5

The goods are invoiced but for availability or whatever reasons only 6 of this particular item are invoiced, which leaves 2 still on order

I need to be able to track the 1 of the 6 invoiced refers to order #1001 , 2 of them refer to order #1002 and the remaining 3 belong to order #1003. I also need to show that there are still 2 pieces outstanding from order #1003 and, that all the 6 invoiced have been allocated to various orders.

Any suggestions
TIA Eoin Fitzpatrick Received on Sun Jun 01 2003 - 18:52:17 CEST