Re: standard rel. rules between 2 main frms with 1-1 rel. and su

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dear Steve:

Firstly thank you for taking the time to respond. I know I am lacking in
understanding because your post tells me I have a round peg and a round hole
but I just can not seem to understand how to put them together. So please
forgive me, I will mull this over untill I understand I know the concept is
core to access and relational databases. I speak specifically of your way of
having a Tbl of Questions and a Tbl of Answers.

I have problems becuase there are some questions that can have more than one
answer, so I need a sub form for the one to many relationship this can cause
to the main answer section.

Again there are another set of questions that only come into play if a
respondent answers yes to a previous question. Thus making records to those
questions redundant on a "No" answer.

When I look at what you are telling me I feel as though my previous two
paragraphs are completly missing the point. I can not conseptualize how a
table of questions can exist separately from a table of answers. In my mind
the Questions are the lables and the answers are the txt boxes. Again I will
think on this. Thanks for the insite.

Yours truly,

TravelingHT


"Steve" wrote:

Your situation is no different than all other database applications. Two
rules apply:
1. Each table should record data of a single entity.
TblQuestionaireAnswerer - each person who answers one or more of
your questions
TblQuestion - The questions in your survey
TblAnswersToQuestions - Each responders to one or more of your
questions

2. The tables should be normalized. One-to-many relationships require at
least 2 tables. Any survey recorded in TblAnswersToQuestions could have
many answers recorded in TblAnswer.

Steve

"TravelingHT" <akwillims75@xxxxxxxxxxx(stopthespamer)> wrote in message
news:23D12824-4035-4380-AEC6-7A8A406DD2A5@xxxxxxxxxxxxxxxx
Dear Steve:

Thanks for the info.

I do realy want to know if in the situation I describe if there is a
convention and what it is if it exists?

Yours Truly,

Traveling HT

"Steve" wrote:

Consider these tables .....
TblQuestionaireAnswerer
QuestionaireAnswererID
FirstName
LastName
<Contact fields>

TblQuestion
QuestionID
Question

TblAnswersToQuestions
AnswersToQuestionsID
QuestionaireAnswererID
DateQuestionsAnswered

TblAnswer
AnswerID
AnswersToQuestionsID
QuestionID
Answer

Steve


"TravelingHT" <akwillims75@xxxxxxxxxxx(stopthespamer)> wrote in message
news:A9445ADC-5044-4068-9757-3BEBEC0CE3AA@xxxxxxxxxxxxxxxx
Dear All:

I have created a form and tables for taking in the info from a
questionnaire. For reasons of insanity and trying to keep to the rules
of
4th
normal planning for my questionnaire, I have created a one to one
relationship between the questions always answered and some questions
only
some times answered to save space.

To connect the two primary forms I created a primary key with auto
number
in
the Always Used Main Table and linked it to a primary key using long
integer
(No Duplicates) in the Sometimes Used Main Table.

I set up an If statement to send the tab to a sub form in the Sometimes
Main Form which worked fine, but Ctrl+Tab out of the subform into
another
subform did lots of weird things depending on if there was a value in
the
first subform, if I added another entry then Ctrl+Tab to the point I
could
not keep track of the variables that would create the changes.

I then looked at my relationships and added a one to many link from the
Sometimes Used Main Table to all the sub tables and now things are
working
fine.

Originally there was only the One to One relationship between the two
main
forms and a One to Many relationships between the Always Used Main
Forms
and
the Subforms.

This now means that both the Always Used Main Table and the Sometimes
Used
Main Table both have One to Many relationships with all of the sub
tables
and
a One to One relationship between the two of the Main Tables!

Is this normal, is it an abomination, what are the rules, can I go to
prison
for this?

Where can I find out about the conventions on this type of situation?

Thanks in advance.

TravelingHT







.

Relevant Pages

  • Re: standard rel. rules between 2 main frms with 1-1 rel. and su
    ... For example, there is a table, TblQuestion, to record all ... TblAnswersToQuestions and TblAnswer. ... TblAnswersToQuestions and a subform based on TblAnswer to record this ... AnswersToQuestionsID ...
    (microsoft.public.access.tablesdbdesign)
  • Re: standard rel. rules between 2 main frms with 1-1 rel. and su
    ... TblAnswersToQuestions - Each responders to one or more of your ... TblQuestionaireAnswerer ... AnswersToQuestionsID ... but Ctrl+Tab out of the subform into ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Subform Totals
    ... In the main form I had some code which restricted the source of the subform ... For each of these fields their is a total field in the form footer. ... The sub form is a bound to a view. ... The questions is why do the total fields in the form footer of the sub ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Booking duplicates
    ... the subform will be bound to the OrderDetail table (not ... There is no error message and the code compiles. ... the sub form? ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • RE: Updating a field property
    ... frmCall Tracking - Issues Log>> SUB FORM ... in a subform, you have to reference the subform control name and it's form ... With your form in design view Select Format, Conditional Formatting ... fields) and the value you want to check for to change the backcolor to white. ...
    (microsoft.public.access.formscoding)