Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

2 Answers 2

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

 
discard

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.