Menu
I need to create some functionality in our SharePoint app that populates a list or lists with some simple hierarchical data. Each parent record will represent a "submission" and each child record will be a "submission item." There's a 1-to-n relationship between submissions and submission items. Is this practical to do in SharePoint? The only types of list relationships I've done so far are lookup columns, but this seems a bit different. Also, once such a list relationship is established, then what's the best way to create views on this kind of data. I'm almost convinced that it'd be easier just to write this stuff to an external database, but I'd like to give SharePoint a shot in order to take advantage of the automated search capabilities.
509
That's why years ago we developed our Associated Items column type, that allows creating relationships between lists that are handled seamlessly within regular SharePoint forms. Creating repeating items within a parent item became easy for everyone!
Right-click one of the columns you've chosen. Click Create Hierarchy to create a parent hierarchy level at the bottom of the table. The columns will copy into the hierarchy as child levels. Enter a name for your new hierarchy.
Procedure. Display the list of pick lists by clicking the plus symbol next to Code Lists then select Pick Lists. In the right side of the dialog, right-click on the list for which you want to create a child list, and from the shortcut menu, select Create Child.
Do it in a separate database, create a page(s) with controls that surfaces the data and run search over that. Loses quite a bit of the SharePoint features though.
Otherwise it may be okay to create a custom field control that will allow you to lookup the data in the other list. The custom field control can be the one to "view" the related data. I know we have done it for parent child relationships between pages on the same list. Not 1-to-N though.
Tough choice either way.
25
Proper Parent/Child in Sharepoint is near impossible without developing it yourself. There is one approach to that here: Simulate Parent / Child relationship in SharePoint 2007 with Folders & Content Types
(Note: This concerns SharePoint 2007. In 2010, Joins make this much easier)
104
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
