If you have many items in your Sharepoint lists you probably noticed that lookup columns are not working good. In most cases you wouldn't like to see all items lookup dropdown, but filter lookup list to see only some items. Typical examples of such situation:

• You want to create lookup from task to a project, but not all projects in projects list, but only open projects. After you complete several projects in your company you need to move closed projects from project list or picking right project from list becomes laborious.
• Another good example is when you have one list with both suppliers and customers. When you need to lookup from invoice to supplier it is better to filter out those items which represent other entities than active suppliers. Of course some customers can be also suppliers so keeping two different lists is not a good option.
  

View Filtered Lookup allows you to create a lookup column that points to a view of target list. In new or edit form items in dropdown list are filtered and sorted using the selected view. You just create a view on a lookup list defining filtering and sorting criteria and then wherever in you portal you can create lookup columns that point to this specified view of lookup list. It's easy to set up and simplifies your portal architecture with filter and cross-site functionality.

For more details, screencast and free fully functional trial download visit IT-Dev Sharepoint components .