Auto Entering ID from one table to another related table
I've got student table where each student has an ID number. Various evaluations are filled out on each student, and I've set up a different table for each evaluation, and then related the tables based on the student ID. What I would like to do is when a new eval form is filled out that there is a script that pulls the student ID from the student table and automatically enters it into the new evaluation record. Each attempt at building a script and using Set field or Get field isn't working. I know there's got to be an easy way to do this. Can anyone help? Thanks!