Make aggregation ProductsInOrder

Jan 25, 2010 at 4:03 AM

Hi!

I think about one idea:

Now in order we have fixed products and we cant change it. But if we will create table to connetc product with this columns:

ProductId

OrderId

Quantity

Will be possible to change products in order after we create order. For example: we can make partial order ( if one or more products we have no in the storage).