We have a custom setting (AllowableCombinations__c) that has the following fields
It has 10 records containing the different allowable combinations of Queue/Type/Area and Sub Area.
We want to know whether it is possible to create a validation rule that can throw error if the record to be saved does not contain any of the combinations using the combinations from the custom setting.
I know we can accomplish this via trigger or via hierarchial picklist.(.but that helps only when the record is created from UI ) but we really want to know whether it is possible to enforce this lookup validation via custom settings.