If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
archive data
Hello,
I have a situation here where I'm drawing pricing info from an AS400 into Access that's being used to select components for a quote. The price info is live so if a price change occurs on the AS400 side, it shows up on the Access side. What I'd like to do is after a quote has been created, I'd like to lock that data so that older quotes don't have it's pricing changed due to a price change that's occured since the quote was issued. What is the best method of "archiving" or locking this data so that historical information remains true to the day that it was created? I was considering creating a second field for the cost and writing it over to that field when the quote was done as a way of retaining historical data but am open to whatever method would be best for this situation. Thanks in advance, Alan |
#2
|
|||
|
|||
archive data
On Wed, 18 Jul 2007 13:34:02 -0700, Alan
wrote: What is the best method of "archiving" or locking this data so that historical information remains true to the day that it was created? Copy it into a field in the quotes table, or (if a quote covers many items) the quote-details table. The price-as-quoted is an attribute of the quote and the item, not of either one alone. John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|