AnsweredAssumed Answered

Seeking advice re: a design to evaluate award nominees...

Question asked by lobue on Nov 2, 2014
Latest reply on Nov 30, 2014 by lobue

In FMP13 I have created a single table of about 40 nominees for awards. Each nominee is eligible for one of four awards -- their record specifies which of the four awards for which they are eligible. There are roughly 25 fields for each nominee. The list of nominees could grow by as much as 2x before we close the nomination window. This was easy.


The problem I now face is the simpliest way to present each of 10 judges with the scoring fields (not yet created) so that there's a unique score for each judge for each nominee. Each nominee will be judged on 4 categories. Each category is rated with a score of 1 - 5; each category is weighted differently for each of the four award categories.


I can easily create individual layouts for each judge, but as I contemplate this I see an exploding # of fields; roughly 40 fields just to track each judge's rating for the category/award combinations times the # of nominees. This seems wrong!


If you're reading this, you've probably guessed that I'm not that experienced in FMP setting up relationships between tables; I see this as an opportunity to stretch my FMP skills, but I'm not in a position to make a career out of this one project.


Any suggestions -- even just directional as how to approach this -- would be greatly appreciated..


Michael LoBue