Jump to content

ERD Table Trouble


Abigail Elizabeth
 Share

This topic is 2285 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

This topic is 2285 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.