how to key in details into subform

hi,
Im currently doing up a database for a tuition centre.
The problem now is, I have to add students into the system. I have a form
already
Currently, the form has the following fields:
First Name
Last Name
Contacts
Level (grade 9,10,11,12)
Subject 1 (english, maths, science)
Subject 2
Subject 3

In my subform, I actually want to add in the classcode which is related to my
other tables
eg. English Grade 9 = 9E-101 (where 101 is the teacher's ID)
however, I do not know how to key it into the subform. is there any formula i
can use?
pls do get back to me soon as this is rather urgent! ]:

On Mon, 30 Nov 2009 03:09:13 GMT, "melzoh" u56567@uwe wrote:

hi,
Im currently doing up a database for a tuition centre.
The problem now is, I have to add students into the system. I have a form
already
Currently, the form has the following fields:
First Name
Last Name
Contacts
Level (grade 9,10,11,12)
Subject 1 (english, maths, science)
Subject 2
Subject 3

In my subform, I actually want to add in the classcode which is related to my
other tables
eg. English Grade 9 = 9E-101 (where 101 is the teacher's ID)
however, I do not know how to key it into the subform. is there any formula i
can use?
pls do get back to me soon as this is rather urgent! ]:

STOP!

You're apparently making a very common mistake: starting building your
database in the middle. If you were building a house, you wouldn't start
framing in the walls before you'ld poured the foundations!

What are your Tables? How are they related? The Tables are *fundamental*; the
Forms are only windows, tools to manage data stored in the tables. If you're
building your form first, you're on the wrong track.

A classic student - class database will have (at least) four tables:

Students
StudentID (Primary Key)
LastName
FirstName
other biographical data, nothing about classes

Classes
ClassCode text, primary key
CourseName e.g. English
other info about the class

Enrollment
EnrollmentID autonumber primary key
StudentID link to Students
CourseID link to Classes

Teachers
TeacherID
LastName
FirstName
other personal data

--

John W. Vinson [MVP]