How to create records when entering data on seperate table
I have the relationship
Courses::__pkCourseID = Enrollment::_fkCourseID
Students::__pkStudentID = Enrollment::_fkStudentID
I want to be able to import student IDs and course IDs into my enrollment table, and somehow have my students table be populated with all of the information as well. Can you instruct me on the most efficient way to do this without creating duplicate student records?