I'm very new to this and a total novice at code, I was trying to do everything I needed to without really getting into the code as it seems like it should be fairly simple.
I am using database collections to create a list of items with a photo, hire price, description, dimensions etc.
There are 6 categories of these hire items, each with it's own page.
I have a database collection with all of the products in with a field to select which category they belong to and then on each page a filter to show only the relevant items in a repeater on the page. All good so far.
My problem is that I would now like to add a repeater across the top of the page with the 6 categories on so the user can easily click between them. This information comes from a linked database collection "Hire Category", referenced in the main collection as a reference field.
When I add that repeater across the top, only the button for the current category appears as the dataset is filtered to that category.
I can't seem to figure out how to filter dataset for the two repeaters in a different way or to have them refer to two different datasets and filter them that way.
Effectively, I assumed I would be able to filter one repeater and have the other repeater unfiltered, can anyone steer me in the right direction please?
Hopefully I've given enough information on the issue and my issue is clear, but please let me know if I'm missing information.