AnsweredAssumed Answered

Relationship problem?

Question asked by paulatkins on Nov 9, 2012
Latest reply on Nov 10, 2012 by paulatkins

Hi, I am building a scoring system for a print judging process.

I have several tables, one is the Entrants table where each entrant is described, given a "PortfolioNumber" and their up to 8 entries' scores are gathered in separate fields.

One of the other tables is the Entries table, where each entry has an ID number, a score that is averaged from 5 judges scores and a "PortfolioNumber" field (plus other details). The "PortfolioNumber" is what I have related between the Entrants and the Entries tables.

 

What I want to do is when a score is entered into the Entry score field (AverageScore), averaged from the 5 judges, that score is fed into the Entrants print score fields entitled "Print1Score" "Print2Score" etc.

 

Why do these calcualtions not work?

 

PrintScore1 = If ( (( Entries::PortfolioNumber = PortfolioNumber ) & ( Entries::PrintNumber = 1 )) ; Entries::AverageScore )

 

PrintScore2 = If ( (( Entries::PortfolioNumber = PortfolioNumber ) & ( Entries::PrintNumber = 2 )) ; Entries::AverageScore )

 

...etc

 

It returns the same score for every print (Print1), ignoring other print numbers.

 

Thank you

Outcomes