First time here guys, trying to solve my problem. I'm not very experienced in VBA but can understand and follow it.
I need to create a macro which after an event does some, in my mind, complicated things. Here's a quick screenshot of my database to set the scene (think its in the attachments).
On the left of the image I have tblStudents so after a new record is created for that table the macro will run and create multiple records for the new student record created. The new multiple records created will go into my tblLevelTracker where the StudentID (autonumber from tblStudent, just created record) will be copied from. It also needs to copy the ObjectiveID from the large pre set list of objectives in tblObjectives. This will mean that there will be about a hundred newly made records for each student. The TeacherID column in tblLevelTracker isn't relevant along with the other fields for now.
Would anyone be able to help me create a macro for this, I can upload more information if needed.
Thanks in advance, George
I need to create a macro which after an event does some, in my mind, complicated things. Here's a quick screenshot of my database to set the scene (think its in the attachments).
On the left of the image I have tblStudents so after a new record is created for that table the macro will run and create multiple records for the new student record created. The new multiple records created will go into my tblLevelTracker where the StudentID (autonumber from tblStudent, just created record) will be copied from. It also needs to copy the ObjectiveID from the large pre set list of objectives in tblObjectives. This will mean that there will be about a hundred newly made records for each student. The TeacherID column in tblLevelTracker isn't relevant along with the other fields for now.
Would anyone be able to help me create a macro for this, I can upload more information if needed.
Thanks in advance, George