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

I would like to have a multi-record lookup field on my contact object, I know I can create a many-to-many relationship structure to do a similar work, but I would like to have just a field, not a related list. I saw on the Task object, there is one field can do exactly what I want, so how to create something like this? Thanks