how to key in details into subform

[melzoh]

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! ]:

 

[John W. Vinson]

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>