Multiple instances of product in one order.
I've only glanced at Northwind, and I think that you'll have to give a more
detailed example, But it's design is for ability to do multiple sales of
the same product. Roughtly speaking, for duplicated sales of the same item,
you enter the item once in products, and multiple times in order details. It
sounds like this is slightly different than your business. If you give a
more detailed example, I think that we could suggest a way that you can make
Northwind work for you in this respect.
|