I have an existing list called Employees and I have added a new column "Company". I would like to create a lookup column using Company but Company is not displaying as an option in the dropdown list or additional fields. The Employee content type does have Company listed. Any ideas why Company is not being listed when creating a lookup column?
Only this types can be displayed as additional fields:
- Single line of text
- Date and Time
- Calculeted single line of text
- External data: OnHandQuantity More info here