the brand, category, and subcategory tables would need to have some way of relating to each other.
you could then use Dynamic Dropdowns which is a part of Data Bridge to filter the other select lists on the page based on the selected brand.
how are your tables defined?
How are you relating a specific brand to a category? or subcategory?