P
Paul H
I have three tables called tblStudents, tblTeachers and tblEnquiries.
tblStudents = StudentID, DOB, Address, etc...
tblTeachers = TeacherID, DOB, Address, etc...
If I just wanted an Enquiries table for Students, creating the fields would
be easy:
tblEnquiries = EnqDate, StudentID, EnqDescription, EnqFollowupDate
Likewise if I just wanted an Enquiries table for Teachers, creating the
fields would be easy:
tblEnquiries = EnqDate, TeacherID, EnqDescription, EnqFollowupDate
But I need a single enquiry table to manage enquiries from both students and
teachers. How do I do this?
Thanks,
Paul
tblStudents = StudentID, DOB, Address, etc...
tblTeachers = TeacherID, DOB, Address, etc...
If I just wanted an Enquiries table for Students, creating the fields would
be easy:
tblEnquiries = EnqDate, StudentID, EnqDescription, EnqFollowupDate
Likewise if I just wanted an Enquiries table for Teachers, creating the
fields would be easy:
tblEnquiries = EnqDate, TeacherID, EnqDescription, EnqFollowupDate
But I need a single enquiry table to manage enquiries from both students and
teachers. How do I do this?
Thanks,
Paul