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...