Event: Action: Create a Table Record when A Different Table Record is Created

[scotharr]

Hi All, (Access Newbie)



I have two Tables "Class Registration" and "Class Grades" These tables share the fields "StudentID" and "ClassID" When I register a student for the class with a Registration Form, I want to automatically create a Grades record and populate the StudentID & ClassID info into this new record.

What is the simplest way to do this? Does the event "after insert" equate to the creation of the record?

Thank you,
Scott

[June7]

AfterInsert event is available when a new record is created, it does not create record.

Why create a record before there is grade data? Saving record into Grades can be code:
CurrentDb.Execute "INSERT INTO [Class Grades](StudentID, ClassID) VALUES(" & Me.StudentID & "," & Me.ClassID & ")"

The Grades table really should not have StudentID and ClassID. Each record in Registration should have a unique ID, can be autonumber. Grades table should have a field that links to ID field of Registration.

Each class will have multiple grades (quizzes, tests, final)? If there is only one grade per class registration then why have a separate grades table?

What if student drops class? Do you delete the registration record? Do you have cascade delete active so the dependent grade records also delete?

Advise no spaces in naming convention, even in table/query/form/report names.