I'm trying to figure out the best way to solve this 'problem'
I have 4 Custom Post Types:
- Players
- Teams
- Matches
- Seasons
And i want to connect them to each other somehow so that i can query the results in the frontend.
This is how i want them to be connected:
- Each Season has many Teams
- Each Team has many Players
- Each Match has many Teams & Players
My first attempt was to connect these 4 types with the Relationship Field (Advanced Custom Field).
For example, in a Season's edit page there is:
Repeater Field -> Sub Field (relationship), Sub Field (Points), Sub Field (Games Played)
With the above method, I came across many problems while querying in the front end.
What would be the best method to achieve the desired results?