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

Your comment:



 (will not be displayed)


 
 
 
 
 

Live Comment Preview:

 
«July»
SunMonTueWedThuFriSat
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567