Hi Guys - I am new to equations.
This is my data structure
ParentRecord (id, name, latest_score[equation] )
|____ ChildRecord (id, ParentRecord.id, date, score)
In the ParentRecord I plan to have an equation field called "latest_score"
Using SQL I would set this value as
SELECT score FROM ChildRecord
WHERE ChildRecord.ParentRecord.id = ParentRecord.id
The purpose is to always have the latest score shown in the parent record.
Can I do this with an equation field? And if so - can somebody provide an example please.