AnsweredAssumed Answered

How to fill in a foreign key?

Question asked by jbadham on Jan 2, 2018
Latest reply on Jan 3, 2018 by philmodjunk

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


John Badham