Cant access all columns in a Document Library to create a lookup column in a Sharepoint List
I am trying to establish a relationship between a Document Library and a Sharepoint list using Lookup columns in the Sharepoint list. When I begin creating/formatting this lookup column, and select the Document Library as my source, I do not have access to all the possible choices for the columns to relate back to the Sharepoint list. For instance, I am looking to relate a choice column called "Document Type" in my Document Library to a Sharepoint list column that references what type of document was uploaded to the library. I dont see any settings that wouldnt allow for my lookup column to be related to the Document Library columns of interest. Is there a reason why I only have access to some of my Document Library columns for a new lookup column in my Sharepoint list?