Database Problem

[Jessika]

I have created a database which deals with courses. I want to have a form which gives me The name of the lecturer delivering the course, The coursename,and the students following the course.
For example If I chose lecturer X for courswe BA in English, I should have all the students following the BA Course in English.
How can this information be updated in a table.


Please find attached file
PLEASE ADVISE
Thanks,

Jessika

 

[jzwp22]

You might want to check out this data model for students and classes

 

[Troy]

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 also. The subform containing a datasheet view is where you would update the courses.

http://www.sellwindowsmedia.com/MS-Access-Software/MS-Access-Software.htm