Geeks With Blogs

News





The SharePoint Hillbilly Fewer Big Words... More Pretty Pictures...

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 on Tuesday, December 8, 2009 2:17 PM | Back to top


Comments on this post: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting 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.
Left by Mike Roosa on Dec 15, 2009 10:29 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting 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
Left by Deb Klenke on Dec 29, 2009 1:08 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting 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
Left by Cameron Smith on Apr 08, 2010 11:04 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting 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)
Left by Howard on May 14, 2010 2:53 PM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting 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!
Left by TJ on Jun 09, 2010 6:44 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting 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
Left by Jordan Jenkinson on Jun 17, 2010 12:19 PM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting 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
Left by Keith Knight on Aug 05, 2010 1:29 PM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting 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
Left by Mark Rackley on Aug 05, 2010 1:53 PM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting 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
Left by Keith Knight on Aug 06, 2010 6:06 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting 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
Left by Keith Knight on Aug 06, 2010 9:23 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
Is there any way to create some type of roll up that will calculate the sum of hours worked per issue?

Thanks.
Left by Tammy on Nov 02, 2010 1:46 PM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
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
Left by Karl on Nov 27, 2010 12:13 PM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
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
Left by Mark on Dec 16, 2010 6:16 PM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
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!
Left by Patrick K. on Dec 30, 2010 9:26 PM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
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?
Left by Kees on Feb 10, 2011 10:28 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
the videos are no longer available???
can u update the references?
Left by Arsalan Adam on Feb 21, 2011 8:53 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
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
Left by Mark on Feb 21, 2011 9:37 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
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
Left by James on Mar 09, 2011 11:31 AM

# Create a Survey from a SharePoint List condition
Requesting Gravatar...
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.
Left by Benjamin on Mar 28, 2011 8:06 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
You are my personal savior! Thank you so much for taking the time to explain this so clearly.
Left by Ronnie on Mar 28, 2011 2:54 PM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
Unfortunately can't find the videos, is there another link to them?

Thanks.
Left by Latte on May 10, 2011 11:37 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
Videos are hosted on YouTube and I just verified that are still working. Sorry for the problems you are having.
Mark
Left by Mark on May 10, 2011 11:45 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
Awesome. Just followed the steps to finished my task.
Left by Eb on May 24, 2011 9:59 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
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?
Left by MNH1 on Jul 13, 2011 7:49 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
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.
Left by Harry on Aug 11, 2011 3:41 PM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
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
Left by Silva on Oct 13, 2011 5:07 PM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
Amazingly useful and very well explained, thanks for sharing. Thanks a lot!!!!
Left by Marcius on Oct 20, 2011 11:45 AM

# re: Creating a SharePoint List Parent/Child Relationship – VIDEO REMIX
Requesting Gravatar...
this is so great! very easy to follow. Many thanks. How do I place a title link from the parent on the child display form, right now there's a id link.
Left by link back to issue from task on Mar 02, 2012 4:24 PM

Your comment:
 (will show your gravatar)


Copyright © Mark Rackley | Powered by: GeeksWithBlogs.net