In Part 1 of this article I tried to solve the problem for SharePoint 2007 with Workflows, but never found the time to complete it and create custom workflow activities for SharePoint Designer. In 2010, SharePoint Designer comes to the rescue, as it has similar workflow activities OOTB!
If you have been reading about exciting new features of SharePoint 2010 you’ve probably heard about something called SandBox Solutions.
This article describes how you can create a filtered lookup for SharePoint 2010. It is easy to use and no code is required to make it work.