Many to many to many

[an]

I need to hold an inquiry to sick persons.
I have:
T_QuestionsGroups: IdGroup (with a primary key) and NameGroup fields;
T_Questions: IdQuestion (with primary key) Question and IdGroup.
T_QuestionsGroups/T_Questions: One to many.
I have too:
T_HaedOfTheHouse: IdHeadOfTheHouse (with primary key) and others fields
T_CollectiveFamily: Some fields and IdHeadOfTheHouse
One to many too.
In addition, to each question to be able many fixed answers, choosed in
T_Answers with IdAnswer and Answer.
So, I have many Questions, many Answers and many Persons but I don't know to
do a relationships between theese three conjuncts.
Thanks in advance.
an

 

[Smartin]

I need to hold an inquiry to sick persons.
I have:
T_QuestionsGroups: IdGroup (with a primary key) and NameGroup fields;
T_Questions: IdQuestion (with primary key) Question and IdGroup.
T_QuestionsGroups/T_Questions: One to many.
I have too:
T_HaedOfTheHouse: IdHeadOfTheHouse (with primary key) and others fields
T_CollectiveFamily: Some fields and IdHeadOfTheHouse
One to many too.
In addition, to each question to be able many fixed answers, choosed in
T_Answers with IdAnswer and Answer.
So, I have many Questions, many Answers and many Persons but I don't know to
do a relationships between theese three conjuncts.
Thanks in advance.
an

Hello,

Speaking to your question about questions, answers, and people, I
propose the model diagrammed at the link below (my website). I'm going
from memory somewhat, but IIRC this is how we do it at work.

http://vfdrake.home.comcast.net/files/interview.pdf

At the heart of this are answers (responses). Responses belong to
questions, which belong to interviews (collections of questions). People
can have many interviews, and vice-versa, hence the joining table
"InterviewPerson".

To model this remember the arrowheads point at the "one" side of a
one-to-many relationship.

HTH

 

[an]

Hi!

Sorry my delay.
Thank you very much for your reply and help.
But I don't undestood in Responses PK,FK1,FK2 to InterviewID, and
In InterviewPerson FK1 to PersonID

Thank you more one tima.
an

 

[an]

Hi, Smartin.

Tell me the next terminology, please:
PK - Primary Key
PK,FK1,FK2 - ?
FK - ?

Thank you.
an

 

[Allen Browne]

FK = Foreign Key, i.e. a field that relates to the primary key of another
table (or at least a uniquely indexed field in another table.)

 

[an]

AB,
Thank you very much.
I have a difficult to aply Smartin Solution in my tables.
Do you know any BD sample, please?
Thanks in advance.
an

 

[Allen Browne]

You can download a sample database for handling questions and answers here:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

There are many unknowns with how you connect people together, but since many
people can be part of a household, you might find this structure
interesting:
http://allenbrowne.com/AppHuman.html

 

[an]

AB,
Many you very much for your sample.

As a matter of fact, the 1st link return:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/Otherdownload.asp, line 32

But the 2nd link it's Ok.
Thanks more one time.
an