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...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
I'm sure there is an easy answer, but no sure I am understanding the question.

So every day you enter a new FX rate ina table.

Then you have a table of future purchases.

Are you looking to lookup the most current FX rate automaticalky into the Purchases table and freeze it? Now I am not understanding which FX Rate you are looking to being into the Purchases record.