Hi everyone,

 I have a requirement where we need to display one recordtype picklist value to only one profile. We have around 100 recordtypes on an object. Each recordtype has around 10 picklist fields. Need to identify a picklist value is there in remaining recordtypes. Also there is field dependencies on these fields. Let say if we select Field1 will show the values specific in Field2 specific to that RT.

Example : Case Object -> Multiple RT's-> Multiple Picklist fields -> Values.

Is there any we can retreive the value of picklist field from recordtype using soql? or We need to write code for this instead of selecting the values manually. Any ideas?

Thanks,
Sirisha