AnsweredAssumed Answered

How to relate tables via intersection table??

Question asked by riya on May 22, 2010
Latest reply on May 24, 2010 by comment_1

Title

How to relate tables via intersection table??

Post

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................................................

Outcomes