How to link these 3 tables:
Advisor table – one advisor has many students. [one to many]
Student table – one student has one advisor [ one to one]
Grant Number table -- ? [this would contain the StudentID assigned by the software and the grant number assigned by our department's internal tracking number.
Both student and advisor share same campus/department.
How do I link the tables so when I open the advisor table it shows the name[s] of each student it has been has been assigned to? Perhaps by the grant number table containing the student ID and the student grant number? Would the grant ID table be a junction table?