Player and Staff relationship change from 1 to 1 to 1 to many
I'm having issues with what appears to be 1-to-1 relationships on Players and Staff.
Players change numbers every year. The current system does not accomodate players having #34 one year and #35 the next year.
Players historic data also changes year on year (for weight).
Staff also change jobs year on year as they progress in their abilities. I cannot figure out how to only show a job (2012 - Assistant Coach) for the 2012 staff directory. And in 2017 show only their new job as Defensive Line Coach. It also only shows the first Job they are assigned. The only solution I can identify is creating multiple copies of the person.
I'm also having a similar issue with a child team and players showing all information that doesn't pertain to the child team of the parent.
Would it be simpler to maintain people's names as a separate list that can have a 1-to-many relationship for each year/season?

2 comments
-
AdminThemeBoy (CEO / Founder, ThemeBoy) commented
Thanks for contributing! We are always looking for ways to improve SportsPress, so we really appreciate your feedback. Feel free to share this around to get it voted up to the top!
-
Carlos Palacios commented
Which sport are you asking about?