Relationship Weirdness

[Codeus]

Hi there,

I wonder if someone can help explain a relationship problem I am struggling with.

I am building a TOG to show the pupil with the highest behaviour score in each school house and have a relationship setup like this: -

the only sorting is on the relationship between houses and behaviour records, sorting them by score in descending order.

the behaviour data table looks like this

and the pupil table is like this: -

but... the problem comes in the portal combining these: -

as you can see, ash is correctly showing 50 - the top score for that house, but it is pulling 'bert' instead of 'stan' from the pupil table (presumably because bert was created first).

It seems like it *should* show 'Stan' as the match between score < - > pupil is on pupilno and 4=stan.

Could someone explain why it doesn't work like that?

Many thanks!

[comment]

See:

http://fmforums.com/forum/showpost.php?post/291896/

[Codeus]

Thank you Comment, I did search but obviously not hard enough.

Cheers