Quite a common requirement you hear from users is the ability to connect data from separate lists and libraries in SharePoint. For example, you might have two lists, one for the client name and another for contacts within that client, and you need to connect the two. Or, you have a document library containing company policies tagged with a department name, a custom list of department names, and other information about departments.
You need to filter one list based on a selection of another list. So in this article, I wanted to explain two options we have when it comes to connecting multiple lists and libraries. The options I describe below are not competing with one another. They are used in different use cases and just represent different ways to connect the lists.