Database Design Question

From: Eoin Fitzpatrick <eoin_at_no.spam.fitzpatrickwholesale.ie>
Date: Sun, 1 Jun 2003 17:52:17 +0100
Message-ID: <V4qCa.16228$pK2.22261@news.indigo.ie>

Hello all,

    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

= total of 8 on order.

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 - 11:52:17 CDT