How to update multiple tables w/ 1 form

[DMAGIC448]

I am trying to figure out how to add records to multiple tables w/ one form. I am making a database for a Home DayCare and I want to add/update records for 5 tables (Student info, Parent 1 Info, Parent 2 info, EC Info, & Vac Info) w/ 1 form. The unique identifier is the students SSN. So how do I tell MS Access to add a records on each table for the matching fields. I've alread made the the form I just need to know how to get MS Access to populate the different tables based on the info in the text boxes that match the correct cloums on each table. PLEASE HELP!!!!

[Stewart Ross]

Hi DMagic448. Sorry you have not had an answer to your question yet; I think it tells you that you are considering things 'wrong way round'.

If you have five tables which are related in some way it would be most unusual for the five tables to be related one-to-one (that is, for each of the records in your tables there is one and only one record that matches in each related table). The norm would be a one-to-many relationship existing (as between a student and that student's potential course enrolments, say).

A single form cannot possibly be used to update five tables simultaneously where one-to-many relationships are involved (at least not unless there is a master form and four subforms included in that main form) which is why you have not had a reply to your question.

It is certain that your design, at least to the stage you had it when you wrote your question, is in error in some way. It cannot be correct that you have developed a form before you have table relationships properly defined.

If you are minded to pursue this, and for all I know it could have been a student project which is now past its submission date, you would benefit I think from reading our HowTo article on database normlisation and table structures.

-Stewart