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.