4 Replies Latest reply on May 24, 2010 2:56 PM by comment_1

    How to relate tables via intersection table??



      How to relate tables via intersection table??


      I am using FileMaker Pro 7, on windows vista .


      I am creating a database for a department. The tables are as below


      Student, Team, events, advisor, title,semester, class,Degree

      intersection tables are:


      Adv_Til , Stu_Degree, STu_Team...


      I am a newbie in filemaker world.Now what i want to know is as below:



      I have these intersection tables and i have connected them using the relationship graph.How do i actually make connections between these tables so that i am able to display the related records through a portal?


      Till now what i have been able to do is very cumbersome, ie. i have been connecting the primary keys of the tables via the intersection table literally


      Example: Take two tables Advisor and Title(Advisor can have title like , Faculty Advisor for example)  tables , i entered the records in these tables.


      Now , i want to connect them through the intersection table Adv_Til. This table has the foreign keys  i.e primary keys of the Advisor and Title tables.

      What i did is in the Adv_Til table , i entered the advisor's primary key against the title's primary key , as per what title the advisor holds.Only after doing this could i connect these two tables.But i guess  that this might not be the way.


      Is there a way that the records from two tables get related automatically in their  intersection table , without doing what i did?? OR is my way the correct way to relate the records.


      I need an answer to this question , as my method is taking a hell lot of time, and i don't think a database should make one do so much work!!


      Please someone answer................................................