We set up a taxonomy term store in SharePoint 2016 to be utilize for tagging documents with metadata within a document library. One of the goals is to achieve a true cascading parent / child / grandchild relationship that will function in datasheet view to quickly assign metadata to the documents.
Parents in the terrm set include Hardware, Software, Disaster Recovery, etc. Children of Hardware would be printers, servers, laptops, desktops and so on and grandchildren would be HP, Dell, Fujitsu, etc.
Children of Software would be Revu Extreme, Acrobat Professional, Rapid Recovery and likewise grandchildren would be Bluebeam, Adobe and Quest.
Within the document library, three managed metadata coumn have been setup which reference the term store. When fillng in the values you do get the nice flowchart diagram to assist in choosing the right value but honestly, you can put any value in any column, just as long as that value exists anywhere in the term set. I can put Adobe in column 1, Fujitsu in column 2 and Disaster Recovery in the third column, all which are in the incorrect columns and unrelated.
Is there a way to lock column one values to only accept parent values, column two values to accept only related children values based on column one's selection, and column three values locked to grandchildren related to to the child record selected in column two?
Thanks in advance for your assistance