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
It sounds like you are half way there.

Make a new relationship which is "reverse".  One X Rate has Many Purchases.  But on the Right side of the Relationships use that Summary field you created [Max Record ID#].

Then simply add a "lookup" field on that relationship to bring the Currency Rate  from that Max Record ID# record to the Purchase records.