This is a software tool that makes the look up function available in SharePoint more powerful yet flexible.

SharePoint Cascaded Look up greatly enhances the default SharePoint look up. It reduces the look up time as the look up searches are made using the filters you have set up. The tool builds child-parent relationships and thus data selected from one field would determine the options presented in another. Child dropdown lists vary according to parent list chosen. You can widen the range of your look up with SharePoint Cascaded Look up web-part. This way the SharePoint Cascaded Look up is able to provide more powerful filter functions than originally available in the SharePoint tools. You will be able to set combination of filters from the source list or target list to filter items in look up field.

Changes in data you make in source list are automatically synchronized to target list. The cascaded look up settings can be saved via the integrated memory feature. It saves Cascaded Look up settings when converting between different Look up column types. Multiple selections from the source list to list items in the target list can be made. Easy conversion between the default SharePoint look up column, Cross-site or Cascaded look up column are possible. Look up items can be filtered by view. To get the full benefit of the tool you’ll need to set things up through the fairly intuitive interface. These are the source column, filter column and parent column. You need to be familiar with the SharePoint tools to be able to comfortably work with this tool. It is quite a handy tool for you.