From: markp28665@gmail.com   
      
   On Wednesday, February 26, 2014 5:26:26 PM UTC-5, Tony Johansson wrote:   
   > We have a many to many relations between Order and Product table.   
   >   
   > We therefore create a connection table in between and call it OrderLine.   
   >   
   > In the product table we have for example a field called Price for a specific   
   >   
   > product.   
   >   
   >   
   > In the OrderLine table we have field such as OrderId and ProductId and   
   > quantity.   
   >   
   > Now to my question is it good to have a price column in the OrderLine table.   
   >   
   > ?   
   >   
   > If we have a price will that mean the total price per line   
   > such as if we have ordered 3 shoes and this specific shoes cost 10 the price   
   >   
   > field in OrderLine would be 30   
   >   
   > //Tony   
      
   I also would expect to see both a unit price column and a quantity ordered   
   column on the order detail line.  Totaling can be done on the invoice so it   
   does not have to be stored on the order line item.   
      
   HTH -- Mark D Powell --   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)