Hey,
Any help would appreciated. Sure this has been asked many a time but I can’t find the exact answer I’m looking for.
I have 2 collections that I wish to cross reference.
The page template for collection 1 holds a series of games with scores, and categories which are the weeks (wk1, wk2, wk3, etc)
Collection 2 has players, with details about the points scored in these games, it also has categories for the weeks (wk1, wk2, wk3 etc) …
I want if I switch the template to current collection 1 category (so if I switch to wk5 in collection 1), for the collection 2 category to also reference wk5 and display the corresponding data.
What you’ve described doesn’t give enough detail to suggest an approach, and there are quite a few. The best one will depend entirely on the UX you want, some SEO decisions, the shape and volume of data…
But the basic approaches are;
Do it all in the CMS. Structure the CMS so that you can create a page containing all of the data you want. I’d have to see the data model to see what’s at the center, but it’s likely either Game or Week.
CMS collection lists + JS, useful for more complex or creating UX’s