Multi-table form

  • Thread starter Thread starter A.Roth
  • Start date Start date
A

A.Roth

I am trying to generate a form for data entry into
multiple tables that are all related. I can't seem to
find any references in the Access help that show me how to
do that. The one reference I find reverts back to a
single entry when it asks which table or query I want to
use as the source. If I generate a query to tie all the
tables together, then the form comes up blank.

I know this has to be simple, since it seems to be a
normal thing that everyone would want to do so I must be
overlooking something easy. Can anyone help?

Thanks so much.
 
Access uses the concept of (parent) form and (child)
subforms to enter data into multiple tables. Each subform
is a form in its own right and updates its own table, which
usually has a one to many relationship with the table
maintained by the parent form.

Hope That Helps
Gerald Stanley MCSD
 
Thanks, Gerald. That helped a lot. I set up the form and
subforms as one form and have only Two remaining
problems: 1. The entry boxes (controls) are all set as
text boxes and I can enter data into most of them.
However, some of the boxes, which all correspond to one
particular table, will not accept any input. The bell
rings when I try to enter something. I have looked at all
the properties both in the form and in the tables and
can't find any differences. Do you have any idea as to
why I can't enter anything?
2. I would like the form to be able to accept new data but
also to display existing data from the underlying tables.
Right now, that doesn't seem to happen. The form comes up
blank no matter what record is selected. How can I change
the properties to display and accept data?

Thanks very much for all the help. I'd be nowhere without
your aid.
 
Can you some provide some specific details for Question 1
1. What are the names of your tables
2. For each form, what is its name and what is its Record
Source
3. Which is the main form and what are the Parent/Child
links between it and each of its subforms.
4. Which form has the text boxes into which you cannot
enter data.
5. For this form, are you able to enter any data at all.

Regarding Question 2, can you check whether the forms have
their AllowEdits, AllowDeletions, AllowAdditions properties
set to Yes.

Regards
Gerald Stanley MCSD
 
I'll do my best.

The names of the tables are HEO2 RVR Status, HEO2 Test
Docs, and TestSteps. TestSteps has a 1-to-many relation to
HEO2 Test Docs, which in turn has a 1-to-many relation to
HEO2 RVR Status.

When I created the form and subforms, I opted for a
continuous form. Its name is HEO2 RVR Status. The
subforms never got named. The whole thing appears as 1
form in both design and run views.

If the Record Source is the same as what the Property
detail calls a Control source then these are all listed as
the appropriate field names.

It seems that I can not enter any data for the second and
third table entries. The first table is fine.

I don't know how to find the status of the AllowEdits,
etc. properties.

From your questions, I must have somehow set this up
wrong. I'll try again while awaiting your reply.

Thanks again for the help.
 
Thanks for those answers.

The way that I approach this type of hierarchy is to design
the forms from the bottom up i.e I would design the form
for the lowest level first, then I would design the next
level and include my first form as a subform to this and
finally design my top level form and include my second form
as a subform to this.

If you wish to e-mail me direct, I can send you a sample
database to demonstrate this.

Hope That Helps
Gerald Stanley MCSD
 
Back
Top