spliting shipment quantities

From: Peter Whalley <peter.carrilho_at_virginnet.co.uk>
Date: 2000/03/06
Message-ID: <VJVw4.84393$V_.50248_at_news1-hme0>#1/1

I am having problems designing a database.

My table "Order Details" has the following fields:

Order ID     Product  ID     Qty ordered     Qty shipped         Etc.
1023             12345             15                         10

I don't know how to split the order into goods that have been shipped and goods that have not been shipped, so that I am able to assess what goods are outstanding.

Can anybody help me?

Stefania

--

http://www.virgin.net/ Received on Mon Mar 06 2000 - 00:00:00 CET

This message: [ Message body ]
Next message: Bernard Peek: "Re: spliting shipment quantities"
Previous message: topmind: "Re: OO fans bashing Joins"
Next in thread: Bernard Peek: "Re: spliting shipment quantities"
Reply: Bernard Peek: "Re: spliting shipment quantities"
Reply: joe_celko_at_my-deja.com: "Re: spliting shipment quantities"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message