Update table

[samdert]

Hi.

I have several tables.

tblStudent_Information

tblSchool_Information

tblTeacher_Information

tbladd_drop_Info

I would like to have certain fields from the School and Teacher tables
populate fields on the Student Information table. Then, I would like to have
fields on the Student_Information table populate some fields on the Add Drop
Info table.

How can I do this?

 

[PC Datasheet]

It dose not sound like your tables are set up correctly if you have to do
this! Your tables should look like:

tblSchool_Information
School_InformationID
< School Information fields>

tblTeacher_Information
Teacher_InformationID
School_InformationID
<Teacher Information fields>

tblStudent_Information
Student_InformationID
Teacher_InformationID
<Student_Information fields>

For add/Drop information, it seems you left out a Courses table so I'm
adding it here ---

TblCourse
CourseID
<Course fields>

tbladd_drop_Info
add_drop_Info
Student_InformationID
CourseID
<Add/Drop fields>