This topic was addressed here: Is there a way to have a subset of custom field values available based on another field value? but no idea was created.
I’d love to be able to create fields that are dependent on each other. Kind of like a Type/Sub-Type field. But the only values you can select on Sub-Type are those that correlate to the Type field.