Most recent value from related table
Slightly muddled FM newbie.
I have a table called Investments related to table called Valuations (on-to-many). I want to populate Investments::Current Price with the most recent Valuations::Unit Price, based on Valuations::Valuation Date. If I need to use this value in later calculations does it need to be stored? The Investments and Valuations tables are represented in a single Layout with a portal showing the Valuations (portal is sorted in descending order).
Any help would be much appreciated.