473,289 Members | 2,155 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Using form to update two different tables

In the interest of avoiding data entry errors, I am seeking a means of entering data (in this case mail address data) into a form , with subsets of that data being recorded into two separate tables.
I cannot merely record the Record ID of one table (with the details) into the second table, since I must "freeze" the data in the second table at the time of entry, while the first table's record may be revised at some later date. (The first is a customer's address details, while the second is for issuing an invoice. The latter must remain unchanged going forward, while the Customer's current address file may change.)
Thanks for the assistance.
May 28 '10 #1
1 2058
gnawoncents
214 100+
Let me see if I understand. To oversimplify it, let's say you have three fields in the form:
- CustomerID
- CustomerAddress
- InvoiceNumber

You want to fill out the form then take CustomerID and CustomerAddress to populate Form1 and CustomerID and InvoiceNumber to Form2.

Then if you were to fill out the form again for the same CustomerID you need the info in Form1 to be updated as necessary with any address change and a NEW record appended to Form2 with CursomerID and the new InvoiceNumber.

Is this what you want? If so, it can be accomplished by running an update and append query when the form closes or you click a button or whatever you choose. The update query for Form1 and an append query for Form2. If this isn't what you're looking for, please let me know.
May 31 '10 #2

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

Similar topics

10
by: Hank1234 | last post by:
Can I use one Data Adapter and one Command Builder to update amny tables? Currently in my data adapter I query two tables and fill them into two tables in a data set. When I make a change to a...
7
by: Paolo | last post by:
I know I should not be doing this, but I find it very useful. I have a database in Access which stores data for a small company. Sometimes we need to add similar information to different tables....
2
by: Tolu | last post by:
Hello I am trying to save information from one form to two tables. I have a table for Student info and Transcript line. I have a form that list all the classes (using text boxes) a student is...
0
by: elmo | last post by:
Hi, I have a transaction table that I need to update from a from. The form should be able to display information from different tables. I have a Learner table with Learner information. I also...
1
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...
3
by: Steve Teeples | last post by:
I am new to database work. I have a very simple database with only two tables linked by a 1:1 relationship. I've read the tables contents into a dataset and bound the two tables to textbox...
1
by: EyesFriedOpen | last post by:
I was trying to post this to the IBM DB2 forum, however I do not have the "New Post" button available when I view the IBM DB2 forum. Therefore, I apologize if this is not the right place for this. ...
5
by: Markw | last post by:
Hello Folks, It's your new mysql and php user looking for some more help. Background: I'm attempting to develop an online SCUBA Diving Log application. My plans are to put it together in pieces...
1
by: nspader | last post by:
I am working on a new DB for something that clearly has not been done yet. As I have been able to find nothing on it. However, I need to start from the begining and I am having trouble setting up...
1
by: DMAGIC448 | last post by:
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,...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.