Price List Price Breaks
Price List Price Breaks
Many of the price lists I am given by suppliers have different prices for different order quantities (price breaks). Is there a 'standard' way of implementing price breaks in databases. Obviously, I don't want to repeat a complete record of Part_Number, Description, Valid_Date, Supplier etc. but I'm not sure creating another related table/form for Quantity, Price and Lead_Time is the answer. Another issue is importing a price list - most of which list price breaks in separate rows.