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...
I appreciate the reply...I believe I have already done what you are talking about see relationships
How do you do this explicitly? Then simply add a "lookup" field on that relationship to bring the Currency Rate from that Max Record ID# record to the Purchase records.
Where I am still struggling is to to get the value of table = Forex Rates row = Max record ID field = "Forex Rate - 1 AUD Buys X USD"
which is now accessible in PURCHASES via Forex Rate-Maximum Record ID#
Stuck into the table = Purchases row = ALL ROWS field = AUD Today
I cannot figure out what type of field to create and what formula? to use to get the value inserted into a field in the PURCHASES table...
