I am in the process of changing the structure of the database in how we handle or customer orders.
In the past, since we seldom had split shipments, we would simple "split" an order by using the same order number (in the header) with an "A" added to the end in essence creating two orders for the same order. Now I want to keep all items on the same order and split the shipments as needed on the Row level. I am going to use an OrderHeader table and OrderRows table. 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. Any arguments would be appreciated. Jim
