All
A simplified explanation for what I try to reach. I use MS Access 2019.
I have a table Students which contains next fields: ID (primary key) and StudentName (long text)
I have a table Courses which contains next fields: ID (primary key) and CourseName (long text)
I have a table StudentCourses which contains fields: StudentID_FK and CoursesID_FK
I now want to create a form with a dynamic editable pivot table in which the cells contain checkboxes which I can select or deselect.
If I add a new course "History" this column must be automatically added.
So: the X is a checkbox which is enabled. The checkbox for Nick in column English is enabled but it is disabled in column Math.
I think I have to add some boolean field in table StudentCourses (eg ToFollow) but then I still do not know how to create a form as below. I tried to create a crosstab-query but that is non-editable.
Student / Course English Math Biology ... Nick X X Peter X Sam X X ...
Regards
Ino