+ Start a Discussion
SF Admin 119SF Admin 119 

How to get a value from one related list and put onto another related list?

I would like to transfer a value from one related list of contact to another related list of contact. For example, I have a custom object called "Emergency Contact", and another custom object called "Social Workers". Both objects are related to contact object. I would like to create a formula field on "Social Workers" to copy the contact info from "Emergency Contact" object so that when I see the record on Social Workers, I can see the Emergency Contact info of the person he/she is serving. Thanks
Best Answer chosen by SF Admin 119
NagendraNagendra (Salesforce Developers) 

Unfortunately, you can't do this using a formula field. Formula fields only traverse from child to parent ( in this case from Social Workers object to Contact object ), but not from parent to child object ( from Contact to Emergency Contact ). So, you won't be able to get to the Emergency Contact record(s) from Social Workers -> Contact. Hope this clarifies. 

Hope this helps.

Please mark this as solved if it's resolved.