Automating Tables to Input?

[Lucy123]

Hi! It's great to find a place where I might get some actual answers! So here's the issue:

I have a main table for student information. On this table is a column for each class. So let's say it reads
History Geography Science


I also have tables that list the students in each class. So I have a history table, a geography table and a science table.

Here's the tricky part: I would like to automate the database so that it will take the ID# from each class table and input it to the column on the main table.

Can it be done?

[MMcCarthy]

I would use 3 table here as there is a many to many relationship between class and student as in one student can attend many classes and one class has many students. Have a look at this tutorial ...

Normalisation and Table structures

If you break up the tables as follows:

tblStudent
StudentID (Primary Key)
StudentName
etc.

tblSubject
SubjectID (Primary Key)
SubjectName
etc.

tblStudentPerSubject
StudentID (Foreign key referencing tblStudent and part or Primary key)
SubjectID (Foreign key referencing tblSubject and part or Primary key)

Mary