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

Updating more than one data table from a single form

P: 1
I have created a program which uses several data tables. There are numerous occasions where I need to update more then on data table from a form. I can't seem to find a way to make this work. Please advise.
Dec 1 '11 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,707
Your question is very bare, so I will answer in the only way possible.

There are two general approaches that allow forms to update multiple tables.
  1. The form is bound to an updatable query which consists of multiple tables joined together.
  2. The form is bound to one table, but also includes at least one subform which is bound to another.
Dec 2 '11 #2

Seth Schrock
Expert 2.5K+
P: 2,951
I'm guessing that an update query is what you are wanting. Check out the following link for information about the update query. http://office.microsoft.com/en-us/ac...010076527.aspx

Be sure to check out the limitations for the update query to see if it will work in your situation. If you need help with implementing the query, just ask.
Dec 2 '11 #3

Expert 100+
P: 446
Hi,
The answere is Yes but we need more details of what you are trying to do to advise on the best 'How'.

I presume you have two tables because you have a one-to-many situation (e.g. one company with many orders, or one parent with many children) You must also have a unique identifier in one table and a matching field in the second, to allow them to be linked.

You would the create two forms, one for child and one for the Parent table. You then embed the 'child' form within the 'Parent' form. This is called a sub-form.(Sorry, I know you said you were a Neophyte not an imbecile but you have to start somewhere!)

The 'Subform/Sub-report' tool is on the Design tab in Access 2010. It's 18th from the left so may be a bit difficult to find.

You might study the Northwind database application that ships with Access, to gain a basic insight of how things are done.
Best of luck.
S7
Dec 2 '11 #4

NeoPa
Expert Mod 15k+
P: 31,707
This is the first of two threads on the same topic. The other has been deleted but some of the responses already posted were good posts so I copied them here (even if the wording of the question is not exactly as the one they were in response to). I've explained to the OP that such behaviour will not be tolerated here.
Dec 3 '11 #5

Post your reply

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