View Single Post
  #2  
Old March 22nd, 2010, 10:46 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default 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.