ERD Table Trouble

[Abigail Elizabeth]

Hi everyone,

[Background: Working with FileMaker Pro 14. Self taught via Lynda.com tutorials and FileMaker Pro for Dummies.]

I am trying to build a simple solution for a new PhD program at my local university. I am running into an issue regarding the make up of my ERD table. Here is my problem: A single student will have two advisors. A single advisor may advise more than one student (a clear many-to-many relationship). However, I do not know how to define my third table without creating a one-to-one relationship between students and this third table. Do anyone have any advice? Thank you in advance.

[comment]

9 minutes ago, Abigail Elizabeth said:

I do not know how to define my third table without creating a one-to-one relationship between students and this third table.

You need a one-to-many relationship between Students and the join table, and likewise a one-to-many relationship between Advisors and the join table, i.e.

Students -< StudentAdvisors >- Advisors

The match fields would be StudentID for the first relationship and AdvisorID for the second one.

 

See also:
http://fmforums.com/topic/50942-portal-grouping-problem/#comment-239210

 

 

Edited March 23, 2016 by comment

[Abigail Elizabeth]

Thank you. Maybe I was just overthinking the relationship between the prospective child table to the two parent tables. I will give this a shot. I appreciate the prompt response.