Display 4 deep many-to-many in forms and tables

[Maryanne]

1) How do I build a form that shows 5 levels of many to many relationships?
1st level-client names. 2nd level- questions. 3rd-recommendations.
4th-client followup.

2)Should the tables be in a string starting with client in one table then
one to many relationship to the next table questions. Then a 1-M rel with
recommendations. Then a 1-M rel with followup? Or should I be using Link
tables.

I would deeply appreciate your assistance and clarification on how to design
this in an MS Access 2003 DB.
Thank you!

 

[John W. Vinson]

1) How do I build a form that shows 5 levels of many to many relationships?
1st level-client names. 2nd level- questions. 3rd-recommendations.
4th-client followup.

2)Should the tables be in a string starting with client in one table then
one to many relationship to the next table questions. Then a 1-M rel with
recommendations. Then a 1-M rel with followup? Or should I be using Link
tables.

I would deeply appreciate your assistance and clarification on how to design
this in an MS Access 2003 DB.
Thank you!

I can't answer because I don't know your requirements.

Does a Recommendation apply to a client? or to a question? Might a
recommendation apply to multiple questions, or would you reenter the
recommendation repeatedly if it did?

Does a Followup apply to a client? or to a question? or to a recommendation?

Try putting together descriptive sentences like

Each Client may <have? ask? be asked?> zero one or more Questions.
Each Question applies to one and only one Client.
Each Question may generate zero, one or more Recommendations.
Each Recommendation applies to one and only one Question.

and so on. Out of these will emerge the logical relationships which you need
to model in your table relationships.

John W. Vinson [MVP]

 

[LifeLovin]

Thank you for your reply. I really appreciate your time and effort in
answering!
That helped me be clear on establishing table relationships for this
question and in the future.
LifeLovin (Maryanne)