I have a document library in which there are two fields.
Category
Subcategory
Both are drop downs and I want Subcategory to be displayed based on Category selected by user. It's a pretty simple functionality which you must have also seen in the form of Country/City drop down.
How do I do this in SharePoint 2007? I don't want to develop or use custom solution for this. I want to use the OOTB form through which you create a new Item in any document library.
Any idea how to do it?