Updating multiple table from one form

I have a database with nine tables, and forms for data entry, no subforms. It is created for students to track all work required to complete their degree. When student information in added for a new student I need to update other tables with their student id.



The student information table has student ID defined as autonumber. How do I update the other tables with the value generated here, and should all the tables with student ID be defined as autonumber, or some other data definition?



Thank you.

for the other tables set the field type to number. Use an sql statement to do multiple inserts.

Cheers, Lol