Now that we have two related lists, it would be nice to filter our list of Products by Vendor. We can easily accomplish this using out of the box List View Web Parts (LVWP).
First we’ll create a new page to host our Web Parts by going to our Pages library:
And selecting a title and Web Part Layout Template:
Next we’ll add a LVWP for our Companies list by clicking “Add a Web Part”:
Then select the Company List:
And click Add:
Now we can similarly add the Products LVWP:
Now that we have both Lists represented on our page, we can configure the LVWPs’ connections to filter products by Vendor. To do this, start with the Products List and from the edit menu select Connections, Get Sort/Filter From, Company:
Select the column in the Company list you wish to filter with (Title):
Then choose the column in the Products list you wish to filter (Vendor):
The page will refresh and you will see radio buttons next to each Company:
Now when you select a Company, the Products list will be filtered to show only products from the selected Vendor:
One last edit to keep things consistent - let's change the title of the Company LVWP to match our filter. To do this, select the edit menu for the Company LVWP and choose Modify Shared Web Part:
In the task pane, update the Title of the Web Part in the Appearance section:
And then press OK. When you exit edit mode, you’ll have your filterable Products by Vendor Page: