Form using checkboxes to link 2 tables

[Counfounded]

Good day,


I am struggling creating a form that let's me do what I am trying to do. Here is my situation. If anyone can help, it would be much appreciated.

I have 3 tables.
tbl_school
tbl_course
tbl_school_course_Joint

I would like to create a form that looks lie the one below that would allow me to specify which school offers which course. Of course, as the list of schools and courses grow, the form needs to reflect this. Any ideas?



School.accdb

[June7]

Could do this but then need lot of code to pass data back and forth between tables and unbound form. And every time you add a school or a course, have to modify table/queries/forms/reports and maybe even code. And could eventually have too many schools and courses to fit the form. Forms do have limited length and width. Recommend not doing this. Path to insanity. Build a normalized data structure (which you appear to already have) and input data via appropriate data entry forms. Then if you want to output data to display in that structure, manipulate data - but again, report design also has limits of width and length.

[Micron]

I think many would use a form/subform design, with school data at the top and related courses in the subform. Could use a split form as well I suppose, but I'm not a big fan of them. New courses created or no longer offered - what you'd have to do is redesign the form, which is poor practice. Your idea doesn't allow you to show that a course that is no longer offered in School A ever was.

[Counfounded]

Many thanks to both of you for this answer. I'll have to figure out a different way of doing this.

Have a nice day!