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
Peddles
Bell
Horn
Choice 2: Car
Automatic Windows
Alarm
Leather Seats
Choice 3: Tractor
Big Tires
Horn
Big Seat
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?