ContributionsMost RecentMost LikesSolutionsRe: trying to load a field in one table (all records) with a field in the most recent record in another tableI 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.Re: trying to load a field in one table (all records) with a field in the most recent record in another tableOK, there are a couple hundred "futures orders" that are going to be "locked in" at some point in the future. When I say locked in I mean the (futures price from a stock market ticker and a currency exchange rate). The PURCHASES table tracks all of these...over time some orders price is locked (which is basically today's market price and today's ForEx rate). For thispieceI am trying to look uptodaysForEx rate and use it in every row of the PURCHASE table to calculate the total cost IF I were to execute the FIXING today. I suppose snapshot could be helpful? I can see in a form, editing an existing record in the PURCHASE table the Lookup field (showing a picklist of all ForEx records) and if I manually select the highest RecordID...It then fills in the correct exchange rate in my field in PURCHASES table. So I can gettothe information, but I am not getting a field in PURCHASES that says RECORD #84 is the Latest Record. I think I need that to make a formula that AUTOMATICALLY fills in the ForEx value from RECORD #84...into the row in PURCHASES I am looking at plus every other row. This way, I can see the TOTAL position IF I were to execute all of the future orders today.Re: trying to load a field in one table (all records) with a field in the most recent record in another tableI 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 CurrencyRate fromthat Max Record ID# record to the Purchase records. Where I am still struggling is toto 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...trying to load a field in one table (all records) with a field in the most recent record in another tableevery 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 purchasesand we want to estimate the total cost of each purchase using the conversion rate... (and some other factors that discount the rate based on how far into the future it is) I have created a summary field to identify the MAX Record ID, so I know what record is the right record to choose...and I can see it in the purchase table but I can not figure out how I fill a field in the Purchase table with the Field value (ConversionRate) for the record = Max Record ID... Please tell me what I am missing?