You'd need tables for lecturers, students and courses. You could have a one to many relationship between lecturer and courses. The main form could contain a combo box containing lecturers - as soon as you select one the subform is populated with courses - so a main subform relationship is needed...