Access 2010 after insert

[redja71]

i am using Access 2010 and i have 3 tables, studentinfo, testscores and attendance.




what i would like is for when i enter the student information into the studentinto table that it copies over lastname, firstname, dateenrolled, studentid and grade into the testscores table and lastname, firstname, dateenrolled into the attendance table.


i enter the information in using the datasheet view.


i have read to use the table tab, after the table is open however the options for after events are greyed out and i am not able to use them.


please advise how i would be able to accomplish this task


thank you

[rzw0wr]

Look on the other forum you posted to.

http://www.excelguru.ca/content.php?...-cross-posters

Dale

[HDobler]

I did not take the time to figure out what forum the original post was in but I do question if setting up a relation is not the way to go here rather than duplicating all of that data. It also makes it a lot easier to change a name if needed.

Why not create a student ID and use that for a 3 table relationship?

[redja71]

i have it set up this way for the other 2 people in the dept who do not know access. i have left things simple and easy for them to understand for when i leave this position. they have no idea how i do what i do just that it gets done.