• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

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

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
Bevos
Asked:
Bevos
1 Solution
 
Justin ImesFull Time SharePoint JediCommented:
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now