Search results

StudentsInClass shows the names of the students in the course. The number/amount of students is unimportant. I need the names to show up automatically.

The requirements are independent of the number of students in the class. tblStudents -StudentsID primary key, autonumber -txtStudentName tblClasses -ClassesID primary key, autonumber -txtClassName tblStudentsbyClasses -StudentsbyClassesID primary key, autonumber -ClassesID (lookup column...

Yes! I will be doing that in the future, but I'm at a point where I have to work with what I have because the system is already in place so its too late to go back and normalize it. But like I said, I'll make this change at some point in the future.

Each class has a different set of requirements unlike any of the others so I created a seperate table for each.

I have a student table where the student's name is input, a classes table where all the available classes are listed. I created a join table callled studentsbyclasses where I can easily input a students entire schedule. Each class has its own seperate table and there are about 50 seperate...

Ok that makes a lot of sense. Thank you for all the help!

Mr. B, you and I are on the same page. I'll have a table for scouts, one with a list of all the badges, troops, times, instructors, directors, program areas the badges fall into, campsite the troops are staying in, fees for some badges, and several tables linking these all together. I was able...

I'm creating a database for my summer camp. Each badge has a different set of requirements. i.e. Climbing requirements = 1a, 1b, 2a, 2b, 2c, 3, 4, 5 and Art requirments = 1, 2, 3, 4 I have to keep track of which requirements the students have finished. Is there an easier/better way to set...