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?