SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

is it possible to replicate a one-to-many relationship in sharepoint lists.

Scenario: I've two libraries - A and B. All documents in library B must belong to one document in the document A. So, when I'm adding a new document in library B, I want to be able to have a dropdown list which is populated from the title of documents in library A.

How is this possible?

share|improve this question
up vote 1 down vote accepted

Create a Lookup column in library B that points to the Title field of library A. When a new item is uploaded, users will then see a drop down list and display all the values of existing items in library A as possible selections.

share|improve this answer
thanks this works! – tommi Nov 8 '11 at 20:06

Sound like you have a good start based on PirateErics response. I might add that if you are looking for a cascading relationship between your Lists look at spservices from Marc Anderson. Here is a link

share|improve this answer
hey thanks for the additional comment. will look in to it tooo. – tommi Nov 8 '11 at 20:06

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.