I need help with classroom management template!

[imnewtoaccess]

I downloaded the classroom management template, and have been working on
customizing it. When I create a new class the students sub-form of the
classes form automatically fills with all of the students in the students
table. I want to make it so that I can pick some students from the students
table - how can I do that?

 

[imnewtoaccess]

Also, when I delete a row (a student) from the sub-form, it removes it
completely from the student table. What I want is to be able to add and
remove student names for a particular class. Is this possible?

 

[Jason Lepack]

You appear to have linked the subform to the "students" table instead
of the "students and classes" table.

Cheers,
Jason Lepack

 

[John W. Vinson]

I downloaded the classroom management template, and have been working on
customizing it. When I create a new class the students sub-form of the
classes form automatically fills with all of the students in the students
table. I want to make it so that I can pick some students from the students
table - how can I do that?

I don't have this template installed, but it sounds like you need to either
change the recordsource of this Subform or create a new table. This
relationship should have three tables: Classes (a list of all the classes);
Students ( a list of all students); and Enrollment, a list of which students
are enrolled in which classes. The Enrollment table should have fields for the
ClassID, the StudentID, and any information specific to this student's
enrollment in this particular class.

The Subform would be based on this Enrollment table; it sounds like it's
currently based on the Student table. On the Subform you could have a Combo
Box based on the student table, bound to the StudentID field in Enrollment.

If you could post the location from which you downloaded this template I'll
check it out - if it's as I fear, I'll have some sharp comments for Microsoft
or whoever created it; this type of many to many relationship is VERY basic
and should certainly be done correctly in any template!!

John W. Vinson [MVP]

 

[Jason Lepack]

I suspect she got it here, and in modifying, mixed it up as I stated
above.

http://office.microsoft.com/en-us/templates/TC010184071033.aspx

Cheers,
Jason Lepack

 

[imnewtoaccess]

This is where I got the template:
http://office.microsoft.com/en-us/templates/TC010184071033.aspx?CategoryID=CT101426031033

Upon closer look, it seems that the students that are listed in the classes
form are not enrolled, it's merely a list of all students. I've been trying
to figure out how to 'enroll' them, and it seems that I have to add them in
the Students and Classes Table - not in the form, which is odd. I would think
it would be a list of enrolled students, not just a listing of all students
in the table. And if I remove a student from the form, it removes their
record completely. What a pain!! I'm not sure where to go from here. I think
it may be way more complicated to start this from scratch, and I'm not that
good at using Access to try to do it all myself.

 

[imnewtoaccess]

Is there anywhere else where I can get a template like this??

 

[Jason Lepack]

As I said above. The database works fine the way it is. You've
changed it so that the subform of the classes form is pointing to the
students table instead of "students and classes" like it was.
Download it again, and you'll find that it will work better.

 

[Jason Lepack]

<sarcasm>Do you ever feel like you're yelling at the top of your lungs
and no one can hear you?</sarcasm>

Look Up There ---^

 

[John W. Vinson]

<sarcasm>Do you ever feel like you're yelling at the top of your lungs
and no one can hear you?</sarcasm>

Look Up There ---^

:-{/

Could be newsgroup propagation - maybe they *can't* hear you. Frustrating I
agree!

John W. Vinson [MVP]