Divide two Fields, Total in another field

[prawln]

Hey guys,

Been googling for ages and I just can't seem to figure this out!

Im making a currency converter and all i need to do is divide the price by
the exchange rate which gives the answer.

USPrice = the price of items
USCurrency = the current US to NZ exchange rate.
USPriceNZ = the NZ price of the item after the exchange

How to i go about this? USPrice and USPriceNZ are in the table and USCurrency
is just a text box so i can add the current exchange rate when i check the
website for it.

Reason i did this was because when I added USCurrency in the table it kept
wanting me to add the currency rate for every single items in it (theres
multiple)

I hope this makes sence.. if not then i fail lol cheers guys!

[pkstormy]

So basically you have multiple USPrice and USPriceNZ records in which you want to perform some calculation on 1 or all of them where the value used in that calculation is controlled by an unsaved integer value entered on the form?

If you want the value you enter on the form to be saved, you could consider saving this value in the same table as USPrice and USPriceNZ. Otherwise there isn't any way to back-trace the computed calculation if you need to. If you don't care about how the calculation is derived, then I'd leave it as is. I do the same thing for some reports.