Re: purpose of subform?

Tech-Archive recommends: Fix windows errors by optimizing your registry

The table tblSubjects

tblSubjects
sSubjectID (PK)
sSubject
sDescription
....add as many fields as you need

tblStudentSubject
ssStudentID (FK - tied to tblStudents PK sStudentID)
ssSubjectID (FK - tied to tblSubjects PK sSubjectID)
ssDescription
....add as many fields as you need

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

"mike" <mike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0B1971D4-58B8-4678-B2CB-99DDCBE439B0@xxxxxxxxxxxxxxxx
Why not have a table for Subjects and put all the Course Topics in one
table.
i can do that.

then how do i specify that the selected student and subject is added as a
new record in tblStudentSubject


.