Thread: Questionnaire
View Single Post
  #7  
Old April 12th, 2006, 06:02 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Questionnaire

Relationships exist between tables, not forms. Nested subforms are fine,
but are not going to create relationships. The relationships come first, at
the table level. That's why I asked about your tables, but maybe it's best
to back up a step first. What real-world situation is your database
intended to address. It sounds as if maybe you want to have an application
form, and a subform on which children are listed, and another subform for
information about each child. In that case you would have an Application
table related one-to-many to a Children table, which is in turn related
one-to-many with a Questions table. In terms of forms and subforms, the
Questions subform would be nested in the Children form, which in turn is
nested in the Application form.
Of course, my understanding may be completely inaccurate. In any case,
there are a lot of unresolved details in my quick explanation.

"Flipper" wrote in message
news
Well, I hope my relationships are set up right...But it could be wrong...
What I mean by subforms is that I have them nested. Basically, I have a
main form called Applications. It has tab controls on that main form.
Each
tab control has a subform on it. One the Subform called Children (which
has
infor about each kid such as name, dob, gender, ethnic). I then put the
Questions form on the children subform. (nested it). But all I get is
blank
fields when I do. The form on its own, not as a subform works fine. It
asks
a question and i have a box for the answers. I don't know how to get it
in
my main form and have it relate to each child.

"BruceM" wrote:

Your meaning is unclear, particularly "when I create a subform and make
it
in the subform". I know you said that your relationships are set up
properly, but something isn't working, so more information is needed. A
description of the table structure (not every field, just the primary
keys,
other fields involved in relationships, and a general description of the
table's purpose) would help.

"Flipper" wrote in message
news
I have tables set up for my questionnaire and responses. I made the
questionnaire into a form and it lists all the questions. When I
create a
subform and make it in the subform, it doesnt list the questions. It
just
lists blank fields. What am I doing wrong?