AnsweredAssumed Answered

Relationship and referencing (newb)

Question asked by FileMakerNovice on Jan 9, 2013
Latest reply on Jan 9, 2013 by philmodjunk

Title

Relationship and referencing (newb)

Post

     Hello,

     Apologies but I really didn't know how to search for this.  Thanks in advance.

     Let's say, I have a database that has 3 tables:  Students, Scores, Averages.

     All are linked with a Student ID that is a unique value.

     I do not know how to make a relationship to show 'averages' show the averages of the scores.  The problem is the relationship.  If I type in the student ID in the averages table, it will show the appropriate average.  How do I relate the tables to not have to copy the Student IDs into the Averages table?  

     I could easy put the 'Averages' fields in the Student table but I would like to separate this into it's own table.

     Again, thanks.

Outcomes