How to automatically 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 enter a students ID and course ID into enrollment and have the database automatically create a record with the students ID and courses they are enrolled in on it in my student records, or update a students record if they already have one. Right now if I type in a students ID their record fills up with the classes they've taken, but that defeats the purpose of entering info into enrollment.