I'm in process of designing a data card that takes the input from user (list) and refers to an excel documents and prompt the user to enter more information based on their choice. For example.
In the data card the user has to choose the equipment type , when chosen lets say ( Bolts) then in excel file there are sub categories for Bolts Types, Material, size, vendor, manufacture and etc.
When the user select the equipment type, I'd like to be able to refer to the excel file and have the user to select the type only with respect to those values.
Equipment Type : Bolt ----> Size:3m ----> manufacture : ABC -----> Material : XYZ -----> and so on
I tried List, however I could not set conditional sub categories for it. Any help is appreciated.