AnsweredAssumed Answered

How to automatically create records when entering data on seperate table

Question asked by AllisonCahanin on Apr 29, 2013
Latest reply on Apr 30, 2013 by philmodjunk

Title

How to automatically create records when entering data on seperate table

Post

     I have the relationship

      

     Courses----<Enrollment>----Students

     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.

Outcomes