Code to assign students to teacher

[jmccullough]

Hello, I am struggling with how to accomplish this. I have an Access db of tblstudents and tblTeachers. What I have been assigned to do is create a button on a Form that when clicked will:

take the students from tblStudents who are registered for Algebra I and assign then to the Teacher in tblTeachers who teaches Algebra I. There is a class size limit of 10 that when reached looks for the NEXT Teacher who teaches Algebra I.

There are also Algebra II, Biology I and II and Literature I and II

Using Access 2010.

Fields in tblStudent are: Student Name, Class, ID and District.

Fields in tblTeachers are: Teacher, Class, EmailAddress and ID.

Any help would be greatly appreciated. Thank you.

 

[jdraw]

This sounds like Homework/Assignment.

Here is a tutorial along the same nature as your problem.
This tutorial will lead you through the steps to create a database. You could then apply the same techniques to your specific problem to solve it.

Good luck with your project.

 

[jmccullough]

Thank you for the quick reply. I already have the db created. Data is actually generated via a web site registration for schools. My db links to the web site tables. I am looking for help on some code to place behind a command button that will automatically assign the students to the teachers.

Thanks.

 

[jdraw]

If you are dealing with an Access/Sharepoint web database, you should make that clear to readers. Some posters deal with web databases, but many don't. I don't so hopefully someone will read through this and respond.

Good luck.

 

[jmccullough]

Not a sharepoint web db, just a plain Access db. I have no coding experience can anyone provide me some direction on how to read in one table and assign limited amount of records from another table ?