SharePoint Online: List Relationships workaround.
Description
The Relationships feature of a list of the current build of Office 365's SharePoint Online does not work on all pages.
This article shows where the Relationships option will work using an example. The trick is to use the List Page itself.
Scenario
I have built two lists as follows.
HR list - This list has Employee ID, Department, Date Of Hire, Position and Full Name. Below is a screenshot of the list settings.
https://7ypnsq.dm2301.livefilestore.com/y2pmTTFTe5qZVRHHn8HCgNgGsembDj37IXaqwdzcXV30aTGJQETHF24ExekmwzmUTHnR0TGzco_UikkcEpPQ3Zon_sh-hHUGqz7IMcIJGfwKFQ/Capture.PNG?psid=1
Facilities - This list has Title, Employee Name, Security Level and Employee ID. The Employee Name and Employee ID are the lookup columns. Below are screenshots
https://7ypnsq.dm2301.livefilestore.com/y2pZsYT7TFmdJcYdFmF_O5NinYRzB6XE_9HwlmVSvEQ_9eadKyRqntmPBrvvnm92ACaci8EDumaQCv_khYx16CzpiSxBAmcvJbBGsW5J6RfUoQ/Capture2.PNG?psid=1
https://7ypnsq.dm2301.livefilestore.com/y2pekJKPBOKM6FlPQ-m6vNhhTgBxrIiGJymsPywCNowxKAE5aKtqixM87y0HR8wo_Ddw37gwVXiMcBGaOb3FPrhClPEzO8HSmTdsaa3Tbxvdsk/Capture3.PNG?psid=1
https://7ypnsq.dm2301.livefilestore.com/y2pV02l1thBPyknVQPw6BH1MevN1YszVEyPvQOn9mObrv3W9YMUqpZlA5EgZPFxFJzirJcHh2sG5wnoacZDNNX2dtOamwwDEIkOIKVyIjZYsK8/Capture4.PNG?psid=1
A scenario where Relationships WILL NOT work.
I have built a page and added it to the Site Pages folder. Below is the screenshot of the new page
https://7ypnsq.dm2301.livefilestore.com/y2pFDzl25kwFEYtoYf5lb4pkm_jlvWfP8fK8odoo1z0KITu8Iw7uRplYgHrDxU2GHdwgc6OaqsiCxb8gudLtN74wzkGfFygsgTMwl2l-kO7ZUM/Capture5.PNG?psid=1
In this page I have added the HR list. After selecting the list I see options associated with this list. On the Web Part ribbon I see the Relationships option, however, in spite of attempting to select anyone of them several times, they do not appear on the page. Below is the screenshot of the HR list in the Test Page. I have also provided a screenshot of the Relationships.
https://7ypnsq.dm2301.livefilestore.com/y2p6Y1BErDSwN7NGRlVEQ7pxD6F4A_Q5PXwJtjFvVaYrhgfrJ0PWT-bTX8yUKoBh4bv33hgqZ3rslTI_GgjK-9AUr2RRLMYQZfoO3lOVgCH4Qo/Capture6.PNG?psid=1
A scenario where Relationships Will work.
Go to the HR List and edit the page. Select the HR list. On the Web part ribbon, select any one of the related list options. You will now see the relationship list show up right below the HR list.
https://7ypnsq.dm2301.livefilestore.com/y2p4LqbGVSCM-25yaP6Zc40-Edu6x9schgm5FMXB61JuS_HTq53SPqFWiRXjAti3jkNoNTejdWuB71DaGN0n-zuGPBum1uYp4UUwjEmFJ3BL4s/Capture7.PNG?psid=1
I have also built a video which walks you through the two scenarios described above.
(Click Here to view the high resolution video)