Controlling which SharePoint term store managed metadata is available in a column of a document library

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
Dave SchaferDirector of ITAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Keyboard CowboyCommented:
Hmm - You might consider cascading lookups for this problem.  Managed metadata is nice in some ways but not fully functional in others.  You can cascade multiple lists using either a jQuery approach with SPServices (a bit tricky) or my favorite - download, install SpEasyForms (free and you only need owner rights at the site level to load the solution).  Very powerful for selectively hiding fields, cascading lookups (one level which is all you have), can put in tabs, columns, rearrange forms, I use it all the time.  Just an idea.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dave SchaferDirector of ITAuthor Commented:
I'll give the SPEasyForms a try on my R/D site if it is compatible with SharePoint 2016.
Keyboard CowboyCommented:
Yes, it works with 2016 and Online as well as 2010/2013.  It's terrific.  Let me know of any issues and I walk you through cascading. there's a video on youtube showing precisely how to do it.
Keyboard CowboyCommented:
information provided addressed question
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.