Solved

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

Posted on 2013-01-11
1
305 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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

728 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now