Updating other field values

[Robster]

I have a query that takes a value, Proposalvalue, and depending on the currency, loc curr, it calculates the currency. It gets the currency value from the currencies table and appends to TableB

eg.
proposalvalue currency
50000 1

Currencies
id Value
1 0.6587

This creates the conversionvalue = 32935 in the TableB.

I have little experience in Access programming so could use some help.

I have a form that can view\edit the data in TableB.
Using this form, I want to be able to change the proposalvalue and for it to automatically update the conversionvalue.

 

[pr2-eugin]

Check this link and see if this calculation is absolutely required : http://allenbrowne.com/casu-14.html

 

[Robster]

Yes I will need this value as it will be in most of the reports.