Search the forum for filtering combobox by another combobox. It has been covered. Below is one example:
Here’s another, which has a little more detail: