Update Tables through 1 form

[jmoyer]

I have a table called Students where the primary key is SSN. I have several other tables (ie Assignment #1, Assignment#2, etc.) where the primary keys are the SSN. I have created a form for Students but I would like to know how (if it possible, I am desperate) with one form to have all the SSN fields in all the tables updated.
I.E when I add a new student in my student table through my Student form, I would like the SSN to be added to my different tables automatically although other information has not been inputed. I would love anyones suggestion. Thank you in advance

 

[Deb in LA]

Think perhaps your assignment tables need a diff primary key. The ssn primary key field in all of your assignment tables should be foreign key fields which link to the student table via the ssn number primary key field in the student table. The primary key field in the assignment tables could just be autonumber fields-but need to be unique.

example:

tblAssignment1
--------------
A1ID (autonumber--primary key)
A1StudentID (foreign key which links to tblStudents StudSSN)
A1Topic (a text field)
A1Grade (a text field)

tblStudents
------------
StudSSN (unique field--primary key)
StudFName (a text field)
STudLName (a text field)


After this is done, establish your relationships between your tables and use ref integrity cascading deletes/updates.
Hope this helps.

Deb

 

[jmoyer]

Thank you for letting me know. I was not aware of that fact.