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

Outcomes