Forum Discussion
Creating mutual relationships between items in a list
I have two lists. One housing all data subject details (these can be children, parents, professionals - all in one DS list) and an enquiry list. I have created lookups between the DS list and Enquiry list to link people with enquiries, however I also want to create links between the DS in the master DS list - eg between a parent and a child or a parent and a professional. AT the moment this is simply by creating a lookup field and selecting one or more Unique ID numbers; but I have to go into each list item and select the reverse relationship each time - what I want is when I select a child link from the parent that the reverse automatically appears in the child's record too. Any ideas?
3 Replies
- If you're using SharePoint Online then your best option is to utilize PowerApps custom forms for your list. Then you'll be able to onSelect of the child from a parent record, set the selection of the related too drop down(other relationship field) based on that selection using a patch when you save it.
Probably mumble if you haven't used PowerApps, but you can def. do it using the customized forms built with it.- I think the label 2016 indicates a SharePoint 2016, but let's wait from the confirmation :-)....totally agree with Paul, trying to build something relational on topo of SharePoint can be some kid of problematic
It seems to me that you want to create a relational database within SharePoint. the question is if you do want to do this in SharePoint. Is this in SharePoint online or on premm?
