I work a lot with different lookup columns and one of the great new features in SharePoint 2010 is the ability to quickly display the associated items on the list forms.
In my example I have two lists:
- Procedures (Document Library)
- FAQs (Custom List)
The FAQ list has a lookup column that allows you to select what procedures the FAQ is associated with. From the procedures list I want to be able to quickly see all of the FAQs that have been linked to my procedure. To do this, you can simply add the related list web part to the display form in the Procedures list.
Open the Procedures list and select the option in the Ribbon that allows you to open the Default Display form:
When the page loads, select the Insert option on the Ribbon and select the Related List dropdown. All of the lists that contain a lookup to the current list will be displayed:
The web part will be added to the page:
Now, when you select to View Properties from the document menu you will see both the properties and the associated FAQs:
Here is a screenshot of the FAQ item that is linked back to Test Document 1 through the lookup column:
I have been using this 2010 feature quite a bit, but I just realized this afternoon that I hadn’t blogged about it yet. I hope you find it as useful as I have!