5 Replies Latest reply on May 22, 2013 7:36 AM by ThomasNyman

    Understanding multiple Table occurrences

    ThomasNyman

      Title

      Understanding multiple Table occurrences

      Post

           Hi

           I'm having a bit of trouble with regards to table occurrences.

           First let me explain my table set up

           Its a small database of a homeowners club. It contains the following tables

           "Members"

           "Properties"

           "Equipment"

           "Documents"

            

           The "members" table contains all relevant member info such as name, adress etc, but also fields for "boardmembers" and the date they became a member and a calculation for when the are up for re-election.

           I kind of thought that the best way to deal with displaying boardmembers is to make a new table occurrence of the table "Members" and rename it "Board", but i'm stuck on whether this new table occurrence needs another primary key. The member table has as its primary key __memeberspk. When one makes a new table occurrence of a table that allready has a table occurrence do you need to have two primary keys?? Or have i completely misunderstood this?