Using the "Select Case..." function
Telesphore wrote:
"Marshall Barton" wrote ...
How do you want to display multiple departments on the form?
Maybe using a subform instead of all those check boxes??
Seems like you need a many-many junction table to keep track
of which students are in which departments.
I don't understand what you are saying about adding a field
to tblIncriptionTable??
In the tblInscription I will add the [Departement] field with these 3
values: "Philosophy";"Theology";"Pastoral" in the combo box. So that the
secretary will write only one of these 3 values through the frmInscription
for each student. She will keep on checking the programm boxes.
What combo box???
If a student can be in more that one department, how can one
field keep track of more than one thing?
--
Marsh
MVP [MS Access]
|