AnsweredAssumed Answered

Two tables or one

Question asked by Andy_1 on Aug 19, 2012
Latest reply on Aug 24, 2012 by Andy_1


Two tables or one


I'm creating a student data base for my school. Im getting confused on an issue:


I have one table for a student's name, and birthday. I also want to put primary and secondary adult contacts... Here is where I'm confussed:

Would I have one table for parents.. because a parent could have more than one child in my building? If so.. how do I set up the data entry? 

I didn't know if this would apply to teachers as well.. would i have one teacher table and assign (somehow, drop down list?) to the student?

Any help would be great.