How Would You: Create a view to score a large number of people on a large number of skills

[Luke_D]

I have a “People” table of several hundred people, a “Skills” table of several hundred skills those people can be evaluated on, and a “Peoples Skills” table that references both of those tables to assign a score of 0 to 3 for any one person on any one skill.

How would you go about creating a user-friendly view that lets you choose a person, then rapidly scroll through the several hundred skills to assign scores (0 to 3, currently just using radio buttons) for that person on those skills? Basically this amounts to selecting a record from the “People” table, showing a list of everything in the “Skills” table, then rapidly adding records to the “Peoples Skills” table for the selected person and the Skills I want to assign a score to. I just don’t know what’s the best design approach that lets me see all the skills at once AND which ones already have scores entered for that person in the same view.