Please excuse the confusing title - I wasn't sure how to articulate this problem. This image should help explain things: Image1

So I have a Site Collection with a list of Products. In a sub-site is a list of Parts which are related to different products using Lookup. It pulls info from the parent table (Product:Priority). In the sub-site, I want to create documents associated with individual Parts, inheriting the metadata from both the Parts list and the Products list.

Ideally the user would upload a document and choose which part it relates to (from a single Lookup field). The other Part information (ID) and Product information would be added to the document's metadata automatically. Is this possible with OOTB sharepoint 2016?

1 Answer 1


No: Using OOTB Sharepoint you cannot create lookups to other (sub)sites.

  • It's the parent site, not another sub-site, that the second level info is pulled from. Does that help at all?
    – Mark E
    Commented Mar 17, 2017 at 9:54
  • The same applies. Maybe the answer is in a termstore using managed metadata: create a termstore for storing the product names. Then you can use those product names in the three sites.
    – JJD
    Commented Mar 17, 2017 at 13:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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