Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum Access Troubleshooter ------------ Excel Courses Excel Index ------------ Code Vault Testimonials Tip Jar

 Home > TechHelp > Directory > Access > Nested Subforms < Aggregate Calculations | Split Database >
 Back to Nested Subforms    Comments List
 Ramona Woitas         2 years ago
This was awesome by the way!  :)

I would like to do something similar to what you did with the ClassF & Students.  Except instead of ClassF, I would create another form called CourseReferenceF, and the student combo would become a course combo. So I could pick 1 or more courses to the Current Course Record.

Purpose 1 - Series of Courses (Current Followups & I would pick Course 2 to 6 under it)

However I can't wrap my head around what the relationship would be, or how to set it up.  The Current Course would not be related back to itself, but it would be to Other Courses.
So the way my brain works - It can't be a 1-1 relationship.

Is it a 1 to Many Relationship then - Where 1 course can be related to 1 or more courses?

Or is it a Many to Many Relationship - Where 1 course could be related to Many other courses?

Thanks
 15 months ago Sorry... I'm not following. Explain it like you would to a 3rd grader.
 Ramona Woitas         15 months ago Your Example - You had 2 Tables (ClassT & StudentT) Connected with a Junction Table (StudentXClassT) - I Get This - ClassF (Continuous) - StudentF (Continuous) Inside of ClassF.   I would like to have my forms work the same (layout & how they work together) - But - I would be using 1 Table (Right?) - CourseT (CourseID, CourseName, CourseLinkID ???) - CourseT would be the Record Source for BOTH Forms. - CourseF (Continuous Form) - CourseLinkF (Continuous) Inside of CourseF. - CourseID 1 - Would NOT Be Related to Itself - But Could Be Related to CourseLinkID 2, 3, and 4 - CourseLinkID 2 - Would NOT Be Related to Itself - But Could Be Related to CourseID 1, 3, and 5 Example - Followup has 6 Parts to it.  Course Name - Followup Part 1 (ID 1), Followup Part 2 (ID 2) etc. - In CourseF up to ID 6. - Followup Part 1 (CourseF) - Is Related to Followup Part 2, Part 3 ... (CourseLinkF) - Which is Inside CourseF

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Nested Subforms.