After Insert

redja71

New member
Local time
Today, 13:38
Joined
Jun 17, 2013
Messages
2
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
 
Your table structure sounds like it is way off.
Google table normalization.
Your student information should only be in one table and related to the tables.

Dale
 
i have to have the student info that way for others in the department who are not as experienced in using access.
 
Sorry to differ with you, however IF a database is properly constructed the users need not know anything about Access but how to enter and retrieve data.

Dale
 

Users who are viewing this thread

Back
Top Bottom