Hi Everyone, I need your help!

I have a Master form and Subform, which linked by Student_ID.

Master Form(Student) is using Student table, which has all the student id, schoolname, homeaddress info.....

Subform(Register) is using RegisterService table which also has a schoolname field (but it should come from student table if the student is be registered).

So, I need my subform do this: when user register a student in subform, the schoolname which relates with this student should be shown up in there.

Thank you so much!

Cindy