Hi guys, I'm a new FM user and just signed in the forum, hope to be posting in the right section (please move the topic if not).

This is the problem I got:

I have 3 fields named euro - usd - chf , set as currency values. Whenever I enter a value in any of those fields a script triggers and it calculates the currency value, i.e. if I type a value into "euro" I get the equivalent in usd and chf.

I have a "Manufacturing" table which contains theese currency fields.

For example:

ManufacturingID = M001

Cost:

Euro = 32

Usd = 42

Chf = 38

Sometimes it could happen that I need to change this manufacturing cost and I want the old cost to be saved in "Manufacturing Cost History" table. I tried to set up a script to do so and also tried to create lookup fields in "Manuf. cost history" but it didn't seem to work. Can anyone help?

Hope everything is clear, thanks in advance!

I created 3 fields in "manufacturing cost history" table named:

"euroHistory"

"usdHistory"

"chfHistory"

The script I tried to set up is this:

"Update price":

GotoLayout [manufacturing cost history]

NewRecord[]

setField[manufacturing cost history::euroHistory;Manufacturing::euro]

setField[manufacturing cost history::usdHistory;Manufacturing::usd]

setField[manufacturing cost history::chfHistory;Manufacturing::chf]

GotoLayout[Manifacturing]

//erase euro-usd-chf

but it doesn't work..can't understand why.