I have a base with a table: Scores that has 2 fields in it. Field 1: TeamName, Field 2: QuizScore
What I would like to accomplish is to generate a leaderboard where the Average QuizScore per TeamName is displayed. There may be several TeamName records with differing QuizScores. I do not want to show the detail records in the Interface. Just the summary records. I'm not sure the best way to do this. I managed to link to table: AvgScores, where I calculate the average. But, I cannot figure out how to do an animation, where when a new record is added to Scores, how to I update AvgScores.
The TeamName is created in another application, so, I can control how it is spelled/formatted. So, I can match a field in AvgScores. But, I can't figure out how to do that either. I'm an old SQL hack...