Is there a way to automatically populate a custom field with data from other parts of Civi?
My use case is simple. We have an arts organization that uses relationships to link "partners" together. The problem is that this information is not always easy to see and requires many clicks to identify the details.
I would like to create an individual contact custom field that shows the "partners" name for each of the individuals that are linked by a household.
Leslie and Shawn each have individual contact records so when I access Leslie's record I would like to see that there is a relationship with Shawn.
It would also be great to see a household donation total in both records.
Any input would be greatly appreciated.