<< My two choices are these: 1) Do not put the ship date in the OrderHeader until the order is completely shipped. This would be easiest to implement since the reports would have little changes to them. 2) Put the Ship date in the OrderHeader but have the report based on the backorder amount in the OrderRows table. This would involve more changes in my present reports but may be the best way to go. >>
With split shipments, the ship date is no longer an attribute of the Order, but rather of the OrderRow. If the _only_ thing you track about the actual shipment is the date it shipped, then you should migrate the ship date column from the header to the detail table. If you track additional information about the split shipment (for instance, tracking number) then you should create a new table called ShippingHeader and put the shipping information (include the shipment date) there. Then, in the OrderRow table keep the column for OrderID that links back to the order header but add a new column ShippingID that links to the ShippingHeader table. -- Larr
