AnsweredAssumed Answered

Most recent value from related table

Question asked by matt.rowe on Jun 15, 2011
Latest reply on Jun 17, 2011 by matt.rowe

Title

Most recent value from related table

Post

Hi

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.

Outcomes