How to change a dropdown column based on a previous column

Hi @Joseph_Blake - if the data is not private or if you can create a sample doc with the two tables would you mind sharing it here. That will help us see the setup and column formats and help faster.