Connected Field

Adding a plus of efficiency to the way you work with built-in lookup columns in SharePoint is something you could do provided that you resort to a software utility such as Connected Field.

The piece of software was designed to help you with precisely that by offering a simple way of building cascading master-detail relationships in lookup columns. It is worth pointing out that these columns can belong either to SharePoint lists of document libraries.

No restrictions are imposed on the number of columns you can chain together. As such, you can create any of the following relationship types: single-to-single, multiple-to-multiple, and single-to-multiple.

It should also be made clear that you can rely on Connected Field as both a regular and cascading lookup and that filtering functionality is available as well.

As for whether linked lookup columns can be added, you can rest assured that you have that option, with their values being modified automatically. Moreover, support for conversion from and to built-in lookup columns is provided, and auto-complete capabilities can be integrated as well.

Last but not least, you may want to know that Connected Field puts at your disposal all the necessary tools to work at a site level, which translates to the possibility of reusing the master-detail relationships you have built at the root of a web page.