I need to use filtering up to 3 levels.  When my client edit the properties of a document, they need to select a Content type.  Based on the content type selected, the level 2 column must only show entries related to selected content type, level 3 must only show entries based on what was selected in level 2 and level 4 should show only entries based on what was selected in level 3.

I've created a content type with 3 site columns - Level 2, Level 3 and Level 4.  Each of those columns get their info from 3 lists/tables.  Each list have a unique field marked with *

When I edit the properties of my document, it does not filter.  Each Level field shows all entries, not filtered.

Where did I go wrong? Any help will be much appreciated.

Hi,

This is the default SharePoint behavior. There are few ways to do achieve it. 

Cascading Columns:

http://www.kwizcom.com/sharepoint-add-ons/sharepoint-cascading-lookup-plus/overview/

http://spservices.codeplex.com/wikipage?title=%24().SPServices.SPCascadeDropdowns

Other way is to show/hide field values using JavaScript/JQUery. In this the onchange event of a drop down is trapped and inside it the field values of the other drop down column are added/removed.

Other option may be revisiting your content types. So, instead of three lookup lists, you will end up 3X3 lists, that is 9 list. Each list will contain the lookup value for a single content type, hence no need for fancy stuff like JQuery and every thing will be cleaner.

Thanks,

Nadeem