1 2 Previous Next 19 Replies Latest reply on Aug 24, 2012 12:51 PM by Andy_1

    Two tables or one



      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.

        1 2 Previous Next