AnsweredAssumed Answered

Many to many to many relationship troubles

Question asked by JoSmo on Apr 20, 2010
Latest reply on Apr 23, 2010 by comment_1

Title

Many to many to many relationship troubles

Post

I am  working on a football stats program in filemaker and I am having a little trouble comprehending some relationships.

I have Players, Teams, and Seasons (or school year)

One team has many players
One team has many seasons
One season has many players
One player can play for many seasons, but only for one team


I am having trouble filtering stats for a single player over multiple seasons.

 

I am now using FMPA 11 and I would consider myself one step above a novice.





Outcomes