By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 1,983 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

Need to Display in a Form a string of 1:M 4 levels deep

P: 1
1) How do I display in a form a string of 1:M relationships? (or does it need to resort to multiple forms?)

* Starts with Client that has consultant and consultation desk. Client has many questions. Question has many recommendations which has many followup replies.

*What I have done so far: I placed client in header of form. Then questions is in a subform.

*Problem: Subform shows many questions but now for each question I need to show many recommendations! and the question is in a row. Then for each Recomm I need to show many followups.

* Similar scenarios: Mission ~ objectives ~ deliverables ~ tasks ~ progress ~ done.

Question 2) What is the best way to design the tables for this client scenario?
* What I have done so far. is this correct? tblClient. one to many to tblQuestions. one to many to tbl Recommendations. one to many to followup results. etc.

I would really appreciate your assistance in clarifying what to do in these 2 questions. I am building a MS Access 2003 database for a non-profit organization. I need to present this piece of the db on Friday 3 August. It would be very helpful to hear from someone soon at least before friday 3 august.
Thank you very much in advance for your attention to this question!
Maryanne
Aug 1 '07 #1
Share this Question
Share on Google+
1 Reply


FishVal
Expert 2.5K+
P: 2,653
1) How do I display in a form a string of 1:M relationships? (or does it need to resort to multiple forms?)

* Starts with Client that has consultant and consultation desk. Client has many questions. Question has many recommendations which has many followup replies.

*What I have done so far: I placed client in header of form. Then questions is in a subform.

*Problem: Subform shows many questions but now for each question I need to show many recommendations! and the question is in a row. Then for each Recomm I need to show many followups.

* Similar scenarios: Mission ~ objectives ~ deliverables ~ tasks ~ progress ~ done.

Question 2) What is the best way to design the tables for this client scenario?
* What I have done so far. is this correct? tblClient. one to many to tblQuestions. one to many to tbl Recommendations. one to many to followup results. etc.

I would really appreciate your assistance in clarifying what to do in these 2 questions. I am building a MS Access 2003 database for a non-profit organization. I need to present this piece of the db on Friday 3 August. It would be very helpful to hear from someone soon at least before friday 3 august.
Thank you very much in advance for your attention to this question!
Maryanne
Hi, Maryanne.

Why not to use subforms nested down to 4th level?
Aug 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.