Forum Discussion

JeffQuestions's avatar
JeffQuestions
Qrew Trainee
8 years ago

trying to load a field in one table (all records) with a field in the most recent record in another table

every day a currency exchange rate record is created (e.g. date  = 25-May conversion rate = 0.765) In a separate table I have a bunch of future purchases and we  want to estimate the total cost o...
JeffQuestions's avatar
JeffQuestions
Qrew Trainee
8 years ago
I want all 200 PURCHASE table rows to be updated each day when a NEW ForEx value is entered into the ForEx table.  The update will be through updating the Formula field that includes TODAY conversion rate.