Scenario - I have a custom list with columns. One of the columns is titled Category as a drop down that lists 3 choices Bike, Car, Tractor. Each category choice has another list of items.
Choice 1: Bike
Choice 2: Car
Choice 3: Tractor
The idea is if I click any of the categories the 3 selections connected to the category would show in the next column as a drop down. Look at the picture. Here is what I am trying to do... I picked Bike the 3 selections appear in the next column as a drop down.
Question - How would I do this in SharePoint? Could I use lookup columns with calculated columns?