I am trying to implement a look up field which checks for a column 'CompanyName' which only exists in a single content type: 'Company Content Type'.
When creating a new document set, the field shows options from other document sets, in which the field I am looking for (and also showing) does not even exist.
Client Content Type - Name, Address, City, Country, Tel No, Description
Company Content Type - Name, Address, City, Country, Tel No, Description, BusinessTelNo, CompanyName
Individual Content Type - Name, Address, City, Country, Tel No, Description, Surname, MobileNo, IndividualName, RelatedCompany
Other Content type: Name, Address, City, Country, Tel No, Description, NotImportant1, NotImportant2
Company, Individual and Other Content Types all inherit from Client Content type.
I created a calculated field for the content types, e.g. CompanyName and IndividualName (CompanyName takes a formola of =[Title], IndividualName takes a formola of =[Title]&[Surname]. This is so to be able to use these in the look up fields.
CompanyName only appears under Company content type.
Related Company in the 'Individual Content Type' is a look up field, which looks for 'CompanyName' and requires it to contain information.
The look up field, when creating a new 'Individual' document set, shows values from content type 'Company' but also from content type 'Other'.
It makes absolutely no sense.
Has anyone ever encountered this?