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

I have two lists, one contains files, each file has one or more ID(depending on its content). These IDs are lookups to another list. Now, I generate another list on fly, this list has the ID column as well (same lookup table). What I need to do is to somehow link the two lists together(many to many relationship i suppose) so that i could see all the files, that have one or more common IDs with the generated list. Any idea, how to do this? I could use SP Designer, Visual Studio or any other tool I guess..



share|improve this question

2 Answers 2

Have you tried joined lists in SharePoint Designer? I am not sure how they work with lookups, but their purpose is exactly what you're trying to achieve - connect two lists through a common field.

share|improve this answer

create a new field of Lookup column type within your document library. Choose the list which you wonna link it to your library and pick the column you need (in this case the ID). So when you upload a new doc you should choose the ID that you will assign with the file from a drop-down list.

share|improve this answer

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.