<< 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

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

Print

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
Gravatar
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 Mark at 12/15/2009 10:37 AM
Gravatar
Mike,

Keeping all things simple, I would suggest passing both the ID and the Title to the New Time Entry form and just storing both values. This is the most simple and straightforward approach. The Title field would not have to be a lookup field, just the ID. If you just HAD to have a drop down of Title names to display and ID's for the value, I would think this could be achieved by converting the IssueID field to a asp dropdownlist? possibly? I have not tried this.

Good luck!
Mark

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

Left by Deb Klenke at 12/29/2009 1:08 AM
Gravatar
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
Gravatar
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
Gravatar
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
Gravatar
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
Gravatar
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
Gravatar
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
Gravatar
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
Gravatar
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
Gravatar
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

Your comment:



 (will not be displayed)


 
 
 
 
 

Live Comment Preview:

 
«September»
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789









About
Twitter











Syndication:

RSS ATOM