Get the value of a field from other form to current form.

Question Status

Verified
win71107 asked a question on 12 Oct 2017 11:34 PM

Hi,

I want to get the relational exchange rate from currency code which is in "change exchange rate" form to the current form's Exchange Rate. Is that any ways to do that? and how the coding look like?

Reply
Suggested Answer
Khoa Nguyen responded on 12 Oct 2017 11:52 PM

Hi Win71107,

There are functions in table 330 Currency Exchange Rate. Take a look at them provides you more information:

Reply
Verified Answer
Zaid Tariq responded on 13 Oct 2017 12:53 AM

- Go to the OnValidate Trigger of the Currency Code and from there get the corresponding record from the Currency exchange table and then, assign the value of Exchange rate in the field

Reply
win71107 responded on 13 Oct 2017 1:54 AM

Do I need to use something like IF FormB.RUNMODAL = ACTION::OK then...?

Reply
Verified Answer
Zaid Tariq responded on 13 Oct 2017 12:53 AM

- Go to the OnValidate Trigger of the Currency Code and from there get the corresponding record from the Currency exchange table and then, assign the value of Exchange rate in the field

Reply
Suggested Answer
Khoa Nguyen responded on 12 Oct 2017 11:52 PM

Hi Win71107,

There are functions in table 330 Currency Exchange Rate. Take a look at them provides you more information:

Reply