How to make a form i need

[Guest]

I have a demographics table (with student ID key, and company, etc), a course
description table (with course ID key, section ID, etc), and a course history
table (with Autonumber key, Section ID, Student ID, etc). I have related the
first and last table through Student ID, and the second and third through
Section ID. What i want to do is create a form that I can use as a course
roster for each course that is run. I want to be able to type in a company,
which will bring up all the employees in the database from which i could pick
who is in the class and what grade they got.

I can set up the easy parts (section ID, date) but can't figure out how to
make a section that would run a query for company and display the personnel,
and then in turn be able to pick who is in the class that date, their grade,
and have the info enter into the Course history table.

any suggestions?

Thanks!

S

 

[Guest]

never mind. I found a classes management template I can use.