Finding a related column within a table
So here's my problem. I have a table that looks similar to this:
I want to be able to display the name of the person with the highest score. I can find the highest score by using the Max() function but how do I get the name to show up in a field?