Have you tried sorting the relationship itself so that the higher value is at the top of the list in the related records?
That should return the highest value among the related records as the "first" value for use in the local table.
I am only an advanced beginner in FM. Does your idea look at "both" related fields? I have many names that when entered may have different relationship values.
Overall, I will have 60-to-70 records each week...some with the same values, but most with 6A vs. 5A or A vs. 2A, etc. If I could have a script or calculation took at the 2 fields and determine the higher value for sorting....that solve things.
I will try your idea.
I hope this makes sense.
Hope springs eternal - but I can't make heads or tails from your description.
Your idea worked Stephen. Thank you.