I'd like to create a query that has students names down the rows( from table1) and the different courses they are on along the column headings(from table 2). The idea being that users can tick for each student which course they are on.
Over time the courses may change name or new ones would be added.
Am I over complicating an idea?
Over time the courses may change name or new ones would be added.
Am I over complicating an idea?