archive data

[Guest]

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

 

[John W. Vinson]

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]