Help with complicated problem.

[chris.f]

(Hope this is in the right place)

Hiya Guys,

I am not new to Access, but have only before created basic databases with simple structures and I am having problems with my latest project.
The idea is to have two tables, “tblStudents” and “tblClasses”. I also want to have a form called “frmClasses” and this is proving a bit of a problem. I am trying to display the class data for each class record on the form (Time, date, details), but below that want a table containing all of the students which are registered to that class, which at the moment is just causing me to go round and round in endless circles.

Sometimes, the form just won’t load and after I change it, it will just put in duplicate records containing the same class data but a separate record for every student in that class.

I have a relationship set up in the database which links the field “ID” in students to the field “student_ID” in Classes. But I think that the problem may be there. I can post a copy of the database if you want.

Any help appreciated,

Chris Farrants

 

[KeithG]

You need 3 table not 2. You need a stundent table which contains info about each student, a class table which contains info about each class, and a ClassEnrollment table which contains the PK's from both of the other tables. Actually you may also need a class schedule table if each class is held more than once. I would read up on normalization.

 

[chris.f]

Cool, thanks for the advice Keith. I will try it out and post back with any progress.

Cheers,

Chris