Tracking Old and new value

[VPK_Access]

Hi,

I have a reqirement to store the old value of a field and new value of a field in a table.

I am able to store the new value.However I am lost on how to get the old value of a field and store it in a table. Could anyone help me out in this?

Thanks in advance.

 

[Galaxiom]

Add an EffectiveDate field to the table and use multiple records for each item.

 

[VPK_Access]

I am sorry I didnt get you. How would I be getting the old value of the field?

 

[gemma-the-husky]

it depends how much history you need.

if you only want the last one, then you could add a last date/last price (say) to the table. When you change the value, save the old details.

controls have an "oldvalue" property, which stores the value before you changed it (which is why you can undo changes). Use these to get at the values you need.

The normalised approach would store ALL the historic changes in a separatre table, rather than just the last one in the same table.