Using the "Select Case..." function
in [Reports]
|
Prev: sort by sum of a field
Next: Assigning a criteria
From: Marshall Barton on 15 Apr 2010 10:42 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]
From: Telesphore on 17 Apr 2010 15:12
Thanks and sorry to answer lately. You are right, about the problem of multiple departments. It will be easier to reduce the multiple programst to one. The departments are only 3 of them, meanwhile the programs are 14. So the the secretary will decide the department to choose. Thank you again. "Marshall Barton" <marshbarton(a)wowway.com> a �crit dans le message de news:m89es5http8e684kqnjonbvgtn6cf21et5(a)4ax.com... > 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] |