Refresh Form

[SRN]

Hi,

Can anyone help!!.

I have designed an Returns form but the problem I have is that It's based on European Currency. Now this changes daily. So my problem is that when i update the new currency prevoius record are not updating. The new currency only works on any new records put in after I have ammended the new currency.

 

[Fizzio]

It depends on what you are trying to show. If, for example, you want to show an accurate record of previous prices then your current structure is ok as it will reflect the currency rate at that time. However if you want the currency change to reflect on all your records, the currency rate needs to be 'looked up' in a table and then the value calculated at source. Ie you store the price in UK currency (or wherever you are) and then calculate the european equivalent in a query before populating the form.

To make things a little more interesting, if you need to keep a track of the previous currency, you will need an audit table with date, currency/rate and then lookup this when calculating your values from a given date.

Does this help?