Oscar Ballot - How do you Tally Votes?


So, with Oscar season around the corner, I thought I’d create a base containing all of the Films, Actors, Categories, etc. Then I’d like to create a form that allows folks to cast their votes in each category (via a form).
When the votes are in - I’d like to update the categories table with the winners in each category and tally the scores for ballots accordingly.

So here is the issue I’m having - How can I can I compare the ballot with the winning film to tally the scores for each ballot? Has anyone ever created something like this?



Hey! I saw this question a few weeks ago and decided to take it on.