Creating a SharePoint List Parent/Child Relationship

<< SharePoint Pictorial Essay | Home | SharePoint Saturday KC/DC – Dirty Deeds Done Dirt Cheap >>

Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Everybody dance now!

Everyone loves a good remix… So… By far my most popular blog post is my entry Creating a SharePoint List Parent / Child Relationship - Out of the Box. I am thrilled that so many have found it useful. However, several questions have popped up from the blog and I’ve learned more since then and wanted to redo the blog. So, what better way than to do it with videos! I broke the entire blog up into 6 different videos for your viewing pleasure. Sorry if I ramble.. but hopefully I get my thoughts across and it makes sense.

If you find any portion confusing let me know and I’ll try and redo it!!! Without further ado… Creating a SharePoint List Parent/Child Relationship – Video Remix….

*Lights fade*

*Hush of the audience in anticipation*

Okay.. okay.. I’ll just get to it.

Video 1 – Creating the Site and Lists

Video 2 – Setting Up Filtered Child List on Parent Display Form

Video 3 – Creating Custom New Page form for New Child Entry

I also start the processing of inserting a link to the new page

Video 4 – Passing the Value of the Parent List ID to the Child New Item Entry Page

As requested, here is the code used for the “insert” link that I use in the video.

<a href="../../Pages/NewTime.aspx?IssueID={$ParamIssueID}" 
onclick="javascript:this.href = unescapeProperly(escape(this.href)); 
GoToLink(this); return false;" target="_self">Create a new Task...</a>

Video 5 – Automatically Setting Parent ID field in Child List from Query String Variable

I also hide the Parent ID field on the Child New Item form to prevent users from mucking it up

Video 6 – Creating Links to Child Entry Display Pages From Child List on Parent Display Form

Share This Post:
Short Url: http://wblo.gs/Zat

posted @ Tuesday, December 08, 2009 2:17 PM

Comments on this entry:

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Mike Roosa at 12/15/2009 10:29 AM

What if you wanted to display the Issue Title in the dropdown but store the Issue ID on the list. Also display the Issue Title on the Time List instead of the Issue ID? I am going to be starting a new sharepoint project next week and this could be very helpful.

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Deb Klenke at 12/29/2009 1:08 AM

Hi Mark,

I loved your videos. They are awesome for list to list relationships. I need something to pass the ID and another field from a parent list to a child pic library on an upload. The ID is visible in the EditForm URL but I cannot get the second field to populate nor can I autopopulate the form. Could you provide any assistance? Thanks Deb

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Cameron Smith at 4/8/2010 11:04 AM

Mark,

Great video. I'm a intermediate level SharePoint user trying to get the values of fields in ListA to autopopulate corresponding fields on ListB. I have a master list right now with about 100 columns (or fields) and i need the values of exactly 16 of those columns to autopopulate columns on another list. A friend of mine pointed me to your blog and web videos but unfortunately i was unable to understand if the parent/child list relationship can be used to accomplish what i need? Am i missing something? Can what i need be done? Any direction and suggestions would be GREATLY appreciated.

Thanks for your time,

Cameron

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Howard at 5/14/2010 2:53 PM

Mark,

I just wanted to say thank you for posting these clear videos. Even a SP beginner like me can put together useful apps.

Cheers,

Howard (UK)

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by TJ at 6/9/2010 6:44 AM

This is the coolest thing ever! It really makes you understand the capabilities of Sharepoint. Thank you so much for these videos. I would never have been able to figure this out on my own. I hope you never take these videos off the web because I'm not sure I can duplicate this without your videos. Your the BEST!

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Jordan Jenkinson at 6/17/2010 12:19 PM

Mark,

Loved the videos, they were very clear and concise about how to do things. I'm having a little trouble duplicating this in Sharepoint 2010 because of the functionality that is already included in sharepoint 2010 with the 'Add new item' on the child list view. I cant seem to find a way to hide this or to change it in a manner that I could override it properly. Any tips or help is very much appreciated.

Jordan

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Keith Knight at 8/5/2010 1:29 PM

This is a revelation.. When we set up our sharepoint site(When i see we!! ME) I was told we couldn't do most of the things we are now doing.. Its videos and blogs like this that help us self taught developers/admins/whatever get through the day.. Well done mate.. Excellent

I dont suppose you have a printable version of this so i can sit down and take it all in??? Just a thought..

Keith

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Mark Rackley at 8/5/2010 1:53 PM

Thanks for the kind words Keith. The closest thing you will find to something you can print out is the earlier version of this blog post:

http://sharepointhillbilly.com/archive/2008/12/24/creating-a-sharepoint-list-parent--child-relationship---out.aspx

It's not as polished and some of the methods are improved in the video (not copying/pasting Javascript for example). But for the most part it's all there.

Good luck!
Mark

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Keith Knight at 8/6/2010 6:06 AM

Thanks mark
Like Mike Roosa i have a list that i need to bring in slightly differently.. i need colleagues to be able to choose a school name from the drop-down rather than an ID.. Is this possible as we have over 650 schools in Birmingham, and i want to attach all the scholl visits to each record..

many thanks again

keith

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Keith Knight at 8/6/2010 9:23 AM

Hi mark
I watched all the videos this time, not just some... this tutorial does everything i want.. thank you.... I have also written all the tutorial out long hand for reference.. WOW Forgot how to write always on the PC these days....

Have a great day

Keith Knight

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Tammy at 11/2/2010 1:46 PM

Is there any way to create some type of roll up that will calculate the sum of hours worked per issue?

Thanks.

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Karl at 11/27/2010 12:13 PM

Is there any way to create functionality after clicking OK on the child page to go back to the parent page? It looks like after you hit OK you are in the Time list and end up having to go back to your Issues list and track down the associated Issue, this might end up being a little time consuming if there are many Issues.

Thanks
Karl

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Mark at 12/16/2010 6:16 PM

Finally got around to doing this in SP 2010:

http://sharepointhillbilly.com/archive/2010/12/16/creating-a-sharepoint-parentchild-list-relationshipndash-sharepoint-2010-edition.aspx

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Patrick K. at 12/30/2010 9:26 PM

Awesome, I just did this on my client's Program management site relating Issues with time/date stamped comments on the issue. Worked out great!

Thanks!

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Kees at 2/10/2011 10:28 AM

Very good post, but there is one thing I am struggling with. When you save the child item the overview page is opened in the browser. Is there a way to show the detail page after saving the child item?

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Arsalan Adam at 2/21/2011 8:53 AM

the videos are no longer available???
can u update the references?

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Mark at 2/21/2011 9:37 AM

Hi Arsalan, the videos are working fine. They are hosted on youtube, so make sure that access is not blocked for you.
Good Luck!
Mark

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by James at 3/9/2011 11:31 AM

Thank you for this tutorial, it's got us half way to what we need...

What about selecting from existing records in the child lists? Sort of a "many-to-many" relationship? Any thoughts or suggestions on this?

Thanks

# Create a Survey from a SharePoint List condition

Left by Benjamin at 3/28/2011 8:06 AM

Hi, I want to initiate a survey from the SharePoint List. The list is used to track the projects and when the status column in the Project tracking list is turned to closed, a survey should be initiated. Once the survey response should be tracked back in the SharePoint list.

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Ronnie at 3/28/2011 2:54 PM

You are my personal savior! Thank you so much for taking the time to explain this so clearly.

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Latte at 5/10/2011 11:37 AM

Unfortunately can't find the videos, is there another link to them?

Thanks.

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Mark at 5/10/2011 11:45 AM

Videos are hosted on YouTube and I just verified that are still working. Sorry for the problems you are having.
Mark

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Eb at 5/24/2011 9:59 AM

Awesome. Just followed the steps to finished my task.

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by MNH1 at 7/13/2011 7:49 AM

Thank for this. It really helped and for the most part I was able to replicate this with Sharepoint Foundation 2010 except that things are a bit different. Do you have these same videos for a Sharepoint Foundation 2010 scenario?

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Harry at 8/11/2011 3:41 PM

I wanted to thank you for the great article and videos. It really helped me a lot. I had to change things up a little because I needed to view/add attachments in my second list.

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Silva at 10/13/2011 5:07 PM

The best tutorial for days I was trying to do some thing like this, but I coulnd not find a tutorial that would include all.
Thanks a million

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Left by Marcius at 10/20/2011 11:45 AM

Amazingly useful and very well explained, thanks for sharing. Thanks a lot!!!!

Your comment:

Title:

Name:

Email:

(not displayed)

Website:

Comment:

Remember Me?

Enter the code shown above

Live Comment Preview:

February

Sun

Mon

Tue

Wed

Thu

Fri

Sat

About

Twitter

mrackley RT @cynicalirony: I found @mrackley http://t.co/th2v56ex > Is there some sort of "Mark Rackley looks like..." club that I'm unaware of? about 13 hours ago

mrackley @robwindsor @elijahmanor It's amazing how little things like that totally change your dev style... love it... about 15 hours ago

mrackley @ericharlan your talking a whole different system and have to do conversions. 1 TB (Turkey Bacon) = .333333333333 B (Bacon) about 15 hours ago

mrackley @elijahmanor cool, thanks.. haven't played with it much and see huge potential, but don't want to confuse people with it. about 15 hours ago

mrackley @ericharlan @crmckinley @coreyroth @robwindsor it goes... bacon -> slab -> pig about 15 hours ago

mrackley @coreyroth a lot about 15 hours ago

mrackley RT @robwindsor: @mrackley Of course you do have to take the Canadian bacon conversion rate into account > eggselent... about 15 hours ago

mrackley There are about 70 Calories in a strip of bacon. I'm going to start Counting calories with bacon as my basis. There's 1 bacon in an egg. about 15 hours ago

mrackley @elijahmanor how do you feel about pass a function as a parameter as a way of separating display and data logic without double iteration? about 15 hours ago

mrackley RT @usher: so you're in need of some @Axceler Bacon for SharePoint Migration? @TheBradChase > great, now I'm gonna get sales calls ;) about 16 hours ago

Blogs You Should Be Reading

Syndication:

RSS ATOM

The SharePoint Hillbilly

Fewer Big Words... More Pretty Pictures...

Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Video 1 – Creating the Site and Lists

Video 2 – Setting Up Filtered Child List on Parent Display Form

Video 3 – Creating Custom New Page form for New Child Entry

Video 4 – Passing the Value of the Parent List ID to the Child New Item Entry Page

Video 5 – Automatically Setting Parent ID field in Child List from Query String Variable

Video 6 – Creating Links to Child Entry Display Pages From Child List on Parent Display Form

Comments on this entry:

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# Create a Survey from a SharePoint List condition

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

Your comment:

Live Comment Preview:

Mark Rackley

About

Twitter

Tag Cloud

Archives

Blogs You Should Be Reading

Syndication: