not sure if I'm getting it correct..
FilterValues gets a list - and that list will be created from the MotherTable to the DaughterTable, ie list(DaughterTable::TheField)
if You are already in the DaughterTable when entering the formula - then the LookingValue might be not in that single field?
Check it out using the dataviewer of FileMaker Advanced
Yes sorry you just made me realize I was complicating things. In the parent table I had a calculation field to get the list (and then called it) but did not need this.
Now I have FilterValue (List ( ActivityExpectationStudent::id_expectation ) ; "EXP0001" )
I think this part is correct now. Both worked but this is much clearer.
Now I would need to search the list of expectations and choose the last one.