How to relationships field on the contact profile

Question

I want to create a relationships field on a contact profile like the 'Current Employer" field. I want to be able to access this new field rather than using the 'Relationships' tab.

Why? I want to retain the 'Current Employer' field. My client, Navy Sailing has over 180 branches around the world. We assist with the management of contacts that belong to those branches (organization), and creating a contact relationship with those branches seems to be the best way to manage the requirements. I need the field on the profile in order to make it easier administrators to edit and to view, rather then multiple clicks to use the tab. (and needs to be an obvious piece of data on the profile)

Is there anyway to get a relationships field on the profile, e.g. directly under the 'Current Employer' field OR in a custom field set elsewhere on the profile???

Carl

Answer 1

The "Current Employer" field is special in that the employer_id is actually stored on the contact record (in the civicrm_contact table on the underlying database). All other relationships are stored only in civicrm_relationship.

Nevertheless, you could fake this:

• Create a custom field of type "Contact Reference". This by itself might meet your needs - do you still need a relationship if you have a contact reference field?
• If so - you can write an extension (if you're not a coder, you can hire one to do this for you) that fires on hook_civicrm_custom. When they contact reference field is changed, a corresponding relationship can also be updated.