Hi All

I am new to this forum and this is my first post. I am a novice in VB

I have made a table in MS Access named Teachers and fields are SrNo number,TeacherName text,Type text,Class text. i have connected it to VB. The problem is I have to do validation check that a teacher of type Class Teacher of a particular class should not become class teacher of another class.

How can this be done. Please Help

Thanks in advance
sweety sinha