I have 2 collections:
collection 1 is called “Category” with almost 10 records.
collection 2 is called “Subcategory” with almost 100 records.
these 2 collections are currently linked.
I have a form that allow user to create a profile, the form has 2 drop downs, one for Category and one for sub-category
i want when user pick a category from the first dropdown, it only shows the relevant sub-category of that item in the second drop down. at the moment both drop downs show full list and there’s no way i can filter either of them.
the select filter for subcategory drop down doesn’t give me an option to filter that based on the content of category dropdown:
i chose other component but it takes you the chain of pages with no end



