Solved

SharePoint Form/List question: Is it possible to have a one to many relationship?

Posted on 2013-01-11
1
344 Views
Last Modified: 2013-01-13
Hi everyone, I was hoping that I could get some help from some of the SharePoint experts here.

I made a team site containing a list associated with an infopath form.  The list contains a few fields (ID, Topic, Author, Original Report Date, Due Date, Notes).  The folks I am working with wanted to also have a record of the update history of a document.  To do this I would want to link another link (ID, Update Date) so that the initial list can have many update dates.  Can this be accomplished in SharePoint?  

I've been trying out every nook and cranny of the list customization settings and I'm coming up short.  Time for some expert help!

Thanks,
Bev
0
Comment
Question by:Bevos
1 Comment
 
LVL 9

Accepted Solution

by:
Justin Imes earned 500 total points
ID: 38768233
You can use a lookup column to link to another list and use the secondary list as drop down data.

Then you can use connected webparts to easily display both sets of list info.

Take a look here for additional information on lookups and relationships

http://office.microsoft.com/en-us/sharepoint-server-help/create-list-relationships-by-using-unique-and-lookup-columns-HA101729901.aspx
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question