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

The relationship between Teams and Players is NOT one-to-many: a team has many players, and a player can have (over time) more than one team.

There are several ways to look at this - I believe my preference would be something like:

http://www.filedropper.com/stats_1

(note that this is an ERD, not a Filemaker relationship graph)