1 Reply Latest reply on Jan 21, 2010 12:03 PM by mrvodka

    Relations

    jjg

      Title

      Relations

      Post

      Hi. I'm new and a bit confused.  I've created 2 tables.  First one is pupils and second is classes (teacher name etc)

       

      Each pupil can attend one or two classes.  Can I link the pupil table to the class table from two fields (Class1 and Class2)?

        • 1. Re: Relations
          mrvodka
             Yes with two table occurrences. However, perhaps you should rethink your structure and have at least 3 tables. One for the students, one for the class information itself, and then an enrollment table.