Multiple Scoreboards / Players

rainwaterstudios

I'm working on a word game and wondering if anyone has any suggestions on how to set up scoring for multiple players;

Currently I have a table with the questions that the game pulls from at random, and a table with completed questions and the score for each question...

My goal is to set up a multiple player system, with each player being able to see the questions they've answered and their scores, without the clutter of questions answered by other players; also, this would enable the players to both answer the same questions when chosen, without skipping questions that they haven't answered but have been given to the other player(s)...