Lookup and Select List Column Schema
This schema helps to narrow down a dropdown list to relevant items, while still maintaining the "a change here affects everywhere" benefit of lookups.
Initial table for the top level items.
Secondary table that further breaks down the top level items.
The data table that puts the two together and uses a Lookup column for Category and a Select List for the Sub Category column.
