I am trying to create some content types, but this also happens when creating new columns in a list.
Ok, here is my setup (which is the most basic way to replicate the issue):
List 1: Department List
Columns: Department Name (Single Line of Text)
List 2: Document Owners
Columns: Document Owner (single line of text), Department (Choice or Lookup from Department List), Email (single line of text), Lookup Field (Calculated).
Content Type: Quality Document
Columns: File Name, Title, Document Owners (Lookup from Document Owners List), Email (pulled in with Document Owner), Then i want to also pull in Department from the Document Owners list.
That is where my problem is. When i select the Document Owners List as the list to get the information from, there isn't the option under "Add a column to show each of these additional fields" to pull in the Department column. This
occurs if i use a Choice in the Document Owners list, or if i do a lookup from the Department List.
My preferred method of implementing this system would be to have a multi-value lookup field in the Department List for Document Owners so that the Owners are attached to the Department, and if the owners change for the department they also change for the
document that is for said department. But, i run into the same issue that i c
View Complete Post