Azu provides many SharePoint 2013 Solutions SharePoint Cascaded Lookup, SharePoint Lookup Field.
Look Up Cross-site Information by Building Parent-child Function
Enhance your default SharePoint Lookup with more features and functions with Cascaded Lookup. Broaden your lookup data but at the same time trim down your choices as you start specifying data on each dropdown menu, thus saving you time with filtered choices.
SharePoint Cascaded Lookup builds relationship between parent and child columns; data selected in one field determines the options in the other field.
SharePoint Cascaded Lookup offers the following features:
#A parent-child relationship can be built, meaning data entered in one field filters the options in the next field. #Set combination of filters from the source list or target list to filter items in lookup field #Changes in data made in source list is automatically synchronized to target list
#Add multiple selections from the source list to list items in the target list;
#Convert lookup columns in SharePoint, Cross-Site, and Cascaded Lookup column;
#Integrated memory feature saves Cascaded Lookup settings when converting between different Lookup column types; #Filter lookup items by view.
||Free to try
Windows Server 2008
||SharePoint Server 2013