I have a custom object that is related to the Case via a lookup which hosts the type of the case and some other variables. One of these variables is Contact Type which is currently a multi-select picklist but can be changed where users select for what contact type this Type is available for.
I was trying to use lookup filters to check the Contact Type value on the Type object and ensure it contains the value of the Case Contacts Record Type however lookup filters cannot handle multi-select picklists nor can they handle formula fields if I was to pull the required information onto the Case object.
Is there any other way I can limit the results in the Type lookup field on the case to ensure the records displayed has a Contact Type that matches the Case Contacts record type? Or any way to create a type of sharing rule for a contact?