AnsweredAssumed Answered

Relationship and referencing (newb)

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


Relationship and referencing (newb)



     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.