How to update multiple tables w/ 1 form

1 New Member

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

Subscribe Reply

3982

Stewart Ross

2,545

Recognized Expert Moderator Specialist

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

Oct 24 '08 #2

Similar topics

5032

SELECT works but UPDATE fails. ?

by: kalamos | last post by:

This statement fails update ded_temp a set a.balance = (select sum(b.ln_amt) from ded_temp b where a.cust_no = b.cust_no and a.ded_type_cd = b.ded_type_cd and a.chk_no = b.chk_no group by cust_no, ded_type_cd, chk_no)

Microsoft SQL Server

1948

Complexity in Posting Payments Using an Update Query

by: Dalan | last post by:

I'm not certain if this is doable in the manner explained below, but I'm certain that there have been Access developers who have done something similar. So whatever insight and assistance that can be provided will be much appreciated. There is a separate Update Query (well several) that consolidate various goods from separate tables for access and selection on a sales/order invoice form. The data which is available is the TagNo,...

Microsoft Access / VBA

12991

how to update dataset w/ multiple table?

by: jaYPee | last post by:

I have search a lot of thread in google newsgroup and read a lot of articles but still i don't know how to update the dataset that has 3 tables. my 3 tables looks like the 3 tables from northwind database that has an employees, orders, and order details. the following are the 3 tables in my sql database students schyrsem

Visual Basic .NET

2700

DataAdapter, sedond update

by: Zorpiedoman | last post by:

I keep getting a concurrency exception the second time I make a change and attempt to update a dataadapter. It appears this is by design, so there must be something I can do to avoid it. Example: I have a dataadapter that contains one table with one row. I change the value of the 'FisrtName' column in that row from Jack to John. I call ..update on the dataadapter it goes through fine. Now I change that same column in that same row...

Visual Basic .NET

3102

Update multiple tables from one form

by: CS | last post by:

I need to update multiple tables from one form using a command button. The info from the different text boxes should then go into the tables. Can someone help me with some example code on how to do this.

Microsoft Access / VBA

3546

Add and update data to multiple tables

by: jpr | last post by:

Hello, I know that this is not the rule but need some help. My datbase has three tables: MASTER TEMPLATES FORMS I have a form which is based on a table named MASTER. I have a primary key set to autonumber and a field SSN which I would

Microsoft Access / VBA

3241

Could not update; currently locked by another session on this machine

by: Access Programming only with macros, no code | last post by:

ERROR MESSAGE: Could not update; currently locked by another session on this machine. BACKGROUND I have the following objects: Table1 - HO (which has about 51,000+ records) Table2 - Contact (which has 68,000+ records)

Microsoft Access / VBA

2493

How to update form information when control source is a query

by: mdk7 | last post by:

I am very new to developing forms and queries with Access. The task that I am required to complete is as follows: Build a form based user interface that displays various information from the underlining tables as well as allow for updating of this information. The problem I am having is that all the information that needs to be displaced needs to ‘created’ using a query ie: the form displays information from multiple sets of tables and...

Microsoft Access / VBA

4085

TableAdapter, INNER JOINs, stored procs, and problems with Update

by: Bogdan | last post by:

Hi, I have a stored procedure that uses JOINs to return columns from multiple tables. I also have another stored proc that that takes a series of params and updates multiple tables. I used the framework to auto-generate a table adapter specifying both stored procs as Get/Fill and Update. The problem is that columns from the JOINed table seem to marked as 'read-only' so trying to update a row results in an exception. BTW, by default a...

ASP.NET

9699

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9562

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10542

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10309

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10068

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6840

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5496

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5625

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3795

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP