Many to many to many relationship troubles
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.