+ Start a Discussion
Jyosi jyosiJyosi jyosi 

Formula fields for master detail relationship

Hello Everyone

We have contact and custom object on the custom object we have a picklist field state.
whenever the pick list value on custom object is CT i need to check the box to true on contact detail page 
I wrote the formula but is not working.

The formala has been written on Contact object
If( 

ISPICKVAL(State_Registration__r.State__c,'CT'),true,false 
)

Can any one help me out where i am going wrong.

Regards,
Jyo
Venkat PolisettiVenkat Polisetti
Jyo,

You can only pull values to children from the Parent, but not the other way.

Contact --> Parent
State Registration --> Child of Contact

You can pull a value from Contact (Parent) on to its related object, State Registration (child), but not the other way round. If the relationship is Master Detail, then you can create a Roll-up summary field on the Contact to pull summary information from State Registration such as a count of  CT residents.

Hope this helps.
 
Venkat
Geoffrey J FlynnGeoffrey J Flynn
Hi Jyosi,

The issue here is that you can have many instances of the detail object for each Contact(master) record, so you can't have it conditional on a single entry.  You could look at a cross-object workflow rule to see if this can somehow work
https://help.salesforce.com/HTViewHelpDoc?id=workflow_cross_object_field_updates.htm&language=en_US
A master-detail is a one to many relationship by definition, so you should revisit your data model here if this is something you are trying to achieve.  There are solutions out there, but they often involve triggers if you can't get a cross-object workflow to work, and can't use a roll-up.  In this case I don't see how it fits.