Relating records to other records in same table - bad idea?

[Jesper F]

I'm making a questionaire database with to groups of
people answering questions, say teachers and students.

Currently the teachers and students are in seperate
tables since I'd like to keep track of which students
belong to which teacher.

The test, question and answer tables are properly
normalized similar to Duane Hookom's "At Your Survey".
And as such it would be better if every possible
respondant has a unique id. Therefore I would like to
have both teachers and students in the same table with an
additional field for identifying whether the records
holds a teacher or a student.

My question is: Is it possible to have both teachers and
students in the same table when I also need to keep track
of which students belong to a teacher? This would
normally be done with two tables and a one-to-many
relationsship, but can I reference within the same table
and does it complicate things when making the forms?

Thanks for your help.

 

[Duane Hookom]

I would probably keep the teachers and students in the same table. Add a
field "TeacherID" to your table that is similar to At Your Survey table
tblSrvRspns. You can then add a combo box to the main survey response form
in the header. This combo box would allow you to select values from the same
table.

 

[Jesper F]

Add a field "TeacherID" to your table that is similar to

At Your Survey table tblSrvRspns.

Thanks Duane. However, I'm not using a generic form for
the questionaires as in your database, but instead I'll
try to do something with either different unbound forms or
a temporary table with one question per column.
Thanks for your help.