By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,910 Members | 1,077 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,910 IT Pros & Developers. It's quick & easy.

How to update multiple tables w/ 1 form

P: 1
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!!!!
Oct 17 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 2,545
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.

Oct 24 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.