I am super stoked that SharePoint 2010 has related lists, I got to try this functionality out just before I left London in September with my previous company Content and Code Ltd, (if you’re in UK and EMEA and you need SharePoint work done, the team there are fantastic, tell them I sent you) I managed to build a SCRUM Backlog site with all the relevant lists looking up each other and displaying their related child items in less than a lunch hour, I can’t wait to see this in action in the real world and to see how this will transform information management within organisations.
There’s a big hole in SharePoint 2007 when it comes to Parent Child lists relationships, I won’t go into why this is and what it all means as there’s lots of articles about it online but I will plonk down a few links that I gathered together that walk through in very good detail how to get Parent Child relationships working in MOSS, hat’s off to the authors for taking the time to put these together.
Mark Rackley’s 3 posts on Endusersharepoint.com – well written and followed up by Mark, nice work mate.
Creating a SharePoint list parent child relationship out of the box
Setting SharePoint form fields using query string variables without using javascript
Passing multiple query string varibles using SharePoint Designer – follow up to the above article
Greg Chan, Program Manager in the SharePoint Designer team put together a very good post and has the big little workaround where the filter doesn’t quite work and you need to add ‘LookupId=’TRUE’ into the mix, tricky to fix, watch out for case sensitivity issues which is where I got caught out a couple of times:
Building a SharePoint Designer mashup
Hope these resources help those out there that won’t be seeing 2010 for a while yet.
Happy relationship building.