Hi Kola Oyedeji,
You Can Store the Product Price in orders table as it will save you from making joins which is more overhead then querying same table and having the prices in it. With Regards Nagaraj.A ----- Original Message ----- From: "Kola Oyedeji" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 01, 2002 6:08 AM Subject: OT: database design question re:product price changes > Hi > > I have a table which holds orders. The productid and the quantity of items > purchased are held in this table amongst other things such as the order > date, customer id etc. Orders are calculated by getting the product cost and > multiplying it by quantity. Its occured to me that if the price of items > changes,because the total of an order is always calculated the order total > for previous orders will change. IS there any better way to store orders and > price info or should I also store the current price of each product when the > order is made in the order table - wouldn't this lead to data being > duplicated? > > Thanks in avance > > Kola > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
