Say I have a cascading dropdown, first I have a dropdown "brand", with brand 1, brand 2 etc. Then a cascading dropdown "model", with model 1, model 2, etc, each model record has a field "brand" to use in the cascading option.
When I change model 1 to be from brand 2 instead of brand 1, and I want to search it in the list of orders (where the brand and model are selected in the dropdowns) it doesn't show up after selecting either brand 1 or brand 2 in the filter, i'm guessing because in the "order" record the saved value is brand 1 -> model 1, which is invalid now.
Is there a way to make it so that these "order" records are updated automatically in this case, or am I going to have to write some php to do the update when a model is assigned to a different brand?
When I change model 1 to be from brand 2 instead of brand 1, and I want to search it in the list of orders (where the brand and model are selected in the dropdowns) it doesn't show up after selecting either brand 1 or brand 2 in the filter, i'm guessing because in the "order" record the saved value is brand 1 -> model 1, which is invalid now.
Is there a way to make it so that these "order" records are updated automatically in this case, or am I going to have to write some php to do the update when a model is assigned to a different brand?