Quick Junction Table question.

[NewShoes]

Hey all,

I have table tblCourse, tblJunction, tblModule. This is to break up the many-to-many relationship between Course and Module. However, i'm not creating the forms that would allow the user to "attach" modules to a course but i'm stuck! I am trying to use a form/subform (form being Course and subform being Modules). Is this a common problem and is there an easy solution?

Many thanks for any help,
-NS

 

[pbaldy]

The subform would be based on tblJunction, with master/child links on your course ID. You'd probably have a combo that was bound to the junction table but got its selections from the modules table.

 

[NewShoes]

Many thanks pbaldy. I actually found a different way of doing it without having to sue junction tables. I just added a Course Detail table for each instance of a course and made a 1-to-Many relationship with Modules.

Thanks,
-NS

 

[pbaldy]

So you have a separate table for every course's details? That's a normalization no-no that I suspect you'll eventually regret.

 

[NewShoes]

So you have a separate table for every course's details? That's a normalization no-no that I suspect you'll eventually regret.

No, I have one table with courses linked to one table with course detail (so I can define years, cohorts etc for each course) then I am attaching modules to the applicable record in course detail.

Hope that makes sense!
-NS