Trouble relating these table; I know I am missing something...

[mvital]

Hello All,

I am trying to build an input form in Access 2003. The form as I see it has three parts. One part captures the site name, address, and question and answers for 6 basic questions. I have more questions on the form (7 thru 10), but each has a series of subquestions yes/no for the property and adjoining property. Therefore, I split the main question into a second part within the form. The third part is the subquestion and the yes/no check option for the property and adjoining property. So at the end I have one main form (consists of the 6 basic questions and site details), two subforms one for the next main questions (7 thru 10) and the other for the subquestion (or question details). Here are the tables:

Question:
7. Are you aware...
8. Are you aware...
9. Are you aware...
10. Are you aware...

SubQuestion:
(**each question above has several subquestions so I will not list them here)

Questionnaire: (this is where the data for the main part of the form will be captured once the info is entered on the form)
site name
address
name
date
question1
question2
question3
question4
question5
question6

...Then I have another table where I capture the subquestion and yes/no answer for Property or Adjoining Property when the option for each subquestion is selected on the form.

QuestionSubQuestion:
subquestion
property_yes/no
adjoiningproperty_yes/no
comments.

Any guidance would help. I played with relationships and get the subforms to work just right. So, I know it's my relationships.

thanks,

MV

 

[dhookom]

I wouldn't create table structures like yours. It looks like way too much work. Consider downloading and reviewing "At Your Survey" found at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lespaul]

Additionally, read the Fundamentals document below to see why this structure doesn't meet the rules of relational database design.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi