Cross reference 2 collection categories

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.

Many thanks.

Here is my public share link: LINK
(how to access public share link)

Hi Aaron,

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
  • CMS collection lists + FS CMS Filter + maybe additional JS
  • Something else. AJAX, Automations, 3rd party data sources…