Each company may contains one or more news in the news list. So in the NewsList1 List we created a lookup column called Company which points to the title column of CompanyList1.
Here is the task: If you want to customise the DispForm.aspx of the company list to also display a list of news that associated with the current company.
Here are the steps on how to do that:1. Firstly, we will need to create a Data View to display News. Since the NewsList1 only have the company title as the reference rather than the companyID. We need to somehow filter the News dataview with the Company Title. So we could create a news data view to connect to the existing data view on the DispForm.aspx in order to get the company title.
9. In the design mode, click the arrow icon on the top right of the created dataview. Choose Filter. Make the company column of the NewsList1 equals to the Title parameter.
10. Save your changes, browse the page, you will see the news are filtered by the Company title.