how to handle changing prices

From: Fernando <spamers_at_must.die>
Date: 2000/02/26
Message-ID: <on3gbsgfvbpd6q19rbr89dgcve1m3nnpa1_at_4ax.com>#1/1


Hi!

        What's the best design to handle changing prices for products? O:-) Different customers will have different discounts, prices may change for special offers, etc...

        Changing a price shouldn't affect previous orders of that same product, besides, I need to audit those changes.

        Any ideas? O:-)

TIA
//-----------------------------------------------
// Fernando Rodriguez Romero
//
// frr at mindless dot com
//------------------------------------------------
Received on Sat Feb 26 2000 - 00:00:00 CET

Original text of this message