Problem with max value in a self-join

[Steverino]

Not sure what's happening -- but since I migrated I can't get the self-join relationship to work to show the maximum value among records (in the self-join relationship). So, for example, I have a self-join to link records with the same assignment name (say, the relationship is called "assignments"). Now when I try Max(Assignments::grade), I don't get any results (even though the records are fine). What simple thing am I doing wrong!??

[aaa]

Works in attachment.Look?

Max.zip

[Steverino]

Thanks -- I figured out that the field I was using for the self-join was not indexed, and needs to be. Very frustrating!

Is it at all possible to define a relationship with a field that isn't indexed?