Forum Discussion
JeffQuestions
7 years agoQrew Trainee
OK, 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 this piece I am trying to look up todays ForEx 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 get to the 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.
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 get to the 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.