Editable calculated expression

[kwatai]

First post, so go easy on me

I have a field in the table that needs to be filled up with American Dollars. However, the user is going to be seeing and entering canadian dollars. For the seeing part, I can have a calculated expression by muliplying the data. However, for the input part I'm stuck. Can't modify calculated fields!

So, I pretty much need a two way black box between the user and the table.

Any suggestions?
Thx
Kenta

 

[kwatai]

Yeah, i thought so. But from my understanding this thing really doesn't work when you've got a continuous form. It seems that all unbounded objects acts together, so all calculations are actually just the result of the first one. Plus, onCurrent applies to only the current form so unbounded boxes don't get updated until the you select it.

Oh well, thx for you help though...

Kenta

 

[kwatai]

Thats actually not a bad idea. Thx for the input.

And sorry for not mentioning the continuous form part... wanted to make the situation as simple as possible.

Kenta