How to display a range of values in a related table
We currently use FileMaker Pro Advanced 10.0v3 running Windows XP Professional SP3.
We have a small database with 2 tables. One table (Schools) holds student data with fields such as School, Grade Level, Student ID, Fall Score, and Spring Score. The second table (Scores) holds student scores with fields such as Student ID, Fall Below score, Fall At Level score, Fall Above score, and Spring Below score, Spring At Level score, and Spring Above score. In the Schools table we have the Fall Below, At Level, and Above score fields linking to the Scores table to display Fall and Spring scores related to each student. However we are not exactly viewing the results we want.
We would like the Fall and Spring score fields to display those range of values specific to the Student from the Scores table. For example a student may score Below, At Level, or Above based on a score of ≤3 (Below), 4 (At Level), or ≥5 (Above). We would like to see (if possible?) thier ≥5 score (whether it is 5, 6, 7, or 10) to appear in the correct field named Fall Above score.
Thanks in advance for your help! :smileywink: