How would you set up a database to show the latest and historical use of resources?
I run a monthly photo competition. We have one to four judges score the images submitted. I’d like to be able to enter the month and year each judge participates.
When I look at my list of judges, I’d like to be able to see when the last time was they participated. I’d also like to be able to see the history of how often they’ve participated over at least a few years. I don’t want to have the same judges participating too often, but I also want to be able to see who has been available if I need to replace someone in a hurry.
What kind of field or fields would I need to set up in my database of judges to be able to quickly see this information? Is there a field type where I can enter a list of participation dates?
Thanks for your help!