hi,
tblName :
NameID
Name
tblSubject :
SubjectID
Subject
tblClasses :
SubjectID
(label Teacher) NameID
(Label Student) Name_1ID
What it does, on a certain subject Person A is Teacher, Person B Student,
however for another subject B is teacher, etc ....
This works fine, but I'm struggling on a form. I have sheet, where I double click on "Teacher" field, opens details.
But I want to be able to see Details of "Teacher" (when doubleclicked), and Student (when doubleclicked")
I found some info (http://allenbrowne.com/ser-35.html)
but don't know how to prefilter the form so only showing the person I doubleclicked, not open a second instance that I need to filter afterwards.
Sam
tblName :
NameID
Name
tblSubject :
SubjectID
Subject
tblClasses :
SubjectID
(label Teacher) NameID
(Label Student) Name_1ID
What it does, on a certain subject Person A is Teacher, Person B Student,
however for another subject B is teacher, etc ....
This works fine, but I'm struggling on a form. I have sheet, where I double click on "Teacher" field, opens details.
But I want to be able to see Details of "Teacher" (when doubleclicked), and Student (when doubleclicked")
I found some info (http://allenbrowne.com/ser-35.html)
but don't know how to prefilter the form so only showing the person I doubleclicked, not open a second instance that I need to filter afterwards.
Sam
