I’m making a simple one to many relationship. students and their assignments in different classes.
I have a student table (parent), a class table (child) with two assignments for two different students each class.
I may need a join table to link them. But I don’t understand how to use the foreign key.
‘’The student table has a StudentID primary key entered automatically. But I don’t know what to enter in the Student ID. foreign key in the Class table. Do I leave it alone? What goes there? I’ve scoured the manuals and videos
any help is greatly appreciated..Thanks