Help with 2 tables on 1 form

[yus786]

Need some assistance with this.

I have 2 tables

Example:

Table 1: TeacherID, TeacherName

Table 2: StudentID, TeacherID, StudentName, StudentAge, ETC

I have defined the relationship using TeacherID (1 to many)

In my form i have various tabs that basically shows the details from Table 2. However in one of my tabs - i want to show the details from Table 1

How is this done?

I hope I've explained in properly.

Thanks for reading

 

[yus786]

Use a separate subform on each tab to avoid confusion.

Thanks that makes perfect sense and it worked too