autogenerating checkboxes

[Angel]

I am in need of a great deal of help I think. I have a table that includes
instructors. I have a seperate table that includes students. Both tables
include a unique course code that can be matched up to both the student and
instructor. The student table includes an instructor field. I am trying to
build a form that will generate a class roster, along with assingment fields,
etc... I am building the form, Cover, wherein the first entry is courseid;
this is a drop down box so the course id can be chose from a table of course
id's. the next field allows the instructor to be picked from the
instructerlist table (would love it if ONLY the instructors who have
previously taught that course showed up in the drop down box.) At this
point, once the instructor is chosen, I would love for a list of every active
student enrolled in that course and/or assigned to that instructor to display
with a checkbox next to the name; upon which one could simply check the
student's names that will be participating. and one last field and/or box
that would give the option to add new students. Can anyone help me?