Cascading drop-down menus in a document library. SharePoint 2010 does not support this by default but you can work around this by using JQuery.
I used the following solution. However, one of the problems I encountered was that datasheet view does not present the values properly. If you try to edit the metadata using datasheet view, the filter will not apply to the sub-category column and you will get a list of all sub categories.
The steps of the solution presented are basically:
- Create a list for the parent category.
- Create a list for the sub category.
- Create the required columns in the list you wish to implement cascading drop downs.