Assigning Lessons to Students with One Click

D

Dave White

Hello Everyone,

I have created three tables to track my students' lessons.

tbl_Students
Last - text - 50
First - text - 50
Class - text - 6
Period - byte - 1
All Four Fields are the Primary Key

tbl_Lessons
LessonNbr - integer
LessonType - text - 1
LessonDescr - text - 50
DueDate - shortdate - 8
All Four Fields are the Primary Key

tbl_JunctionStudentsLessons
Last - text - 50 (1 to many from tbl_students)
First - text - 50 " "
Class - text - 6 " "
Period - byte - 1 " "
LessonNbr - integer (1 to many from tbl_Lessons)
LessonType - text - 1 " "
LessonDescr - text - 50 " "
DueDate - shortdate - 8 " "
Note - text - 50
Grade - Integer

I want to assign all the fields from tbl_lesson to any student in
tbl_student.

Any suggestions would be appreciated.

Dave
 
Top